30% OFF - 10th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY10
Entity Framework Subtract Two Dates Discover How to Use Date in LINQ
How to subtract two dates?
How to determine the number of days between 2 dates using LINQ with Entity Framework? Let's take a look at a very simple example where we want to retrieve all those orders which are placed in the last 100 days.
using (var ctx = new MyContext()) { int noOfDays = 30; var orders = context.Invoices .Where(i => DateTime.Now.Subtract(s.Date).TotalDays > noOfDays) .ToList(); }
when you execute the above code, then it will throw the following exception.
System.NotSupportedException: LINQ to Entities does not recognize the method 'System.TimeSpan Subtract(System.DateTime)' method, and this method cannot be translated into a store expression.
StackOverflow Related Questions
Answer
The easiet way to subtract two dates using LINQ is to define a DateTime
variable that represents the old date, then use that DateTime
variable in where portion of the LINQ query.
using (var context = new EntityContext()) { int noOfDays = 30; DateTime oldDate = DateTime.Now.Subtract(new TimeSpan(noOfDays, 0, 0, 0, 0)); var invoices = context.Invoices .Where(i => i.Date > oldDate) .ToList(); }
ZZZ Projects