LINQ to Entities for subtracting 2 dates

entity-framework datetime linq-to-entities
Michael I picture Michael I · Feb 20, 2009 · Viewed 47.6k times · Source

I am trying to determine the number of days between 2 dates using LINQ with Entity Framework. It is telling me that it does not recognize Subtract on the System.TimeSpan class

Here is my where portion of the LINQ query.

where ((DateTime.Now.Subtract(vid.CreatedDate).TotalDays < maxAgeInDays))

Here is the error I receive in the VS.NET debugger

{"LINQ to Entities does not recognize the method 'System.TimeSpan Subtract(System.DateTime)' method, and this method cannot be translated into a store expression."}

Am I doing something wrong or is there a better way to get the number of days between 2 DateTimes in the entity framework?

thanks Michael

Answer

Morten Christiansen picture Morten Christiansen · May 12, 2011

The accepted answer is better in this case, but for reference you can use the EntityFunctions class to perform operations on dates, among other things.

where (vid.CreatedDate >= EntityFunctions.AddDays(DateTime.Now, -maxAgeInDay))

Related questions

Linq where clause compare only date value without time value

var _My_ResetSet_Array = _DB .tbl_MyTable .Where(x => x.Active == true && x.DateTimeValueColumn <= DateTime.Now) .Select(x => x); Upper query is working correct. But I want to check only date value only. But upper …

Read More
Conversion of a datetime2 data type to a datetime data type results out-of-range value

I've got a datatable with 5 columns, where a row is being filled with data then saved to the database via a transaction. While saving, an error is returned: The conversion of a datetime2 data type to a datetime data type …

Read More
Linq to EntityFramework DateTime

In my application I am using Entity Framework. My Table -Article -period -startDate I need records that match => DateTime.Now > startDate and (startDate + period) > DateTime.Now I tried this code but its now working Context.Article .Where(…

Read More