How do I use SQL’s GETDATE() and DATEADD() in a Linq to SQL expression?

by

Try this:

[Function(Name="GetDate", IsComposable=true)] 
 public DateTime GetSystemDate() 
 {   
    MethodInfo mi = MethodBase.GetCurrentMethod() as MethodInfo;   
    return (DateTime)this.ExecuteMethodCall(this, mi, new object[]{}).ReturnValue; 
 }

EDIT: this needs to be a part of your DataContext class.

Now you can use GetSystemDate() instead of DateTime.Now in your queries.
As for date differences take a look at System.Data.Linq.SqlClient namespace, especially DayDiffXXX functions of SqlMethods class.

More Related Contents:

  1. efficient way to implement paging
  2. Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
  3. How to store a list in a column of a database table
  4. Linq version of SQL “IN” statement
  5. How can you handle an IN sub-query with LINQ to SQL?
  6. Is there a difference between Select * and Select [list each col] [duplicate]
  7. Doesn’t Linq to SQL miss the point? Aren’t ORM-mappers (SubSonic, etc.) sub-optimal solutions?
  8. LINQ to SQL query using “NOT IN”
  9. Linq to SQL: How do I stop the auto generated object name from being renamed?
  10. SQL JOIN and different types of JOINs
  11. Split comma separated values to columns in Oracle
  12. How to SELECT FROM stored procedure
  13. Oracle SELECT TOP 10 records [duplicate]
  14. SQL Inner-join with 3 tables?
  15. Call a set-returning function with an array argument multiple times
  16. What datatype to use when storing latitude and longitude data in SQL databases? [duplicate]
  17. How do you import a large MS SQL .sql file?
  18. Difference between Subquery and Correlated Subquery
  19. Database EAV Pros/Cons and Alternatives
  20. sqlplus statement from command line
  21. Conditional logic in PostDeployment.sql script using SQLCMD
  22. How to rename something in SQL Server that has square brackets in the name?
  23. SQL Server 2008 paging methods?
  24. How do I ALTER a PostgreSQL table and make a column unique?
  25. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  26. SQL not recognizing column alias in where clause [duplicate]
  27. How to compare dates in SQL Server
  28. Backup a single table with its data from a database in sql server 2008
  29. How to use SQL LIKE condition with multiple values in PostgreSQL?
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment