Linq to EntityFramework DateTime

by

When using LINQ to Entity Framework, your predicates inside the Where clause get translated to SQL. You’re getting that error because there is no translation to SQL for DateTime.Add() which makes sense.

A quick work-around would be to read the results of the first Where statement into memory and then use LINQ to Objects to finish filtering:

Context.Article.Where(p => p.StartDate < DateTime.Now)
               .ToList()
               .Where(p => p.StartDate.AddDays(p.Period) > DateTime.Now);

You could also try the EntityFunctions.AddDays method if you’re using .NET 4.0:

Context.Article.Where(p => p.StartDate < DateTime.Now)
               .Where(p => EntityFunctions.AddDays(p.StartDate, p.Period)
                   > DateTime.Now);

Note: In EF 6 it’s now System.Data.Entity.DbFunctions.AddDays.

More Related Contents:

  1. LINQ Query to Convert string to datetime
  2. compare the month part with linq [closed]
  3. Linq: help me to make this work
  4. ‘Contains()’ workaround using Linq to Entities?
  5. How to use a string to create a EF order by expression?
  6. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  7. The type of one of the expressions in the join clause is incorrect in Entity Framework
  8. Entity Framework DateTime and UTC
  9. LEFT JOIN in LINQ to entities?
  10. LINQ to SQL multiple tables left outer join
  11. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  12. How to compare only date components from DateTime in EF?
  13. How to Bulk Update records in Entity Framework?
  14. Entity Framework 6 Code First Custom Functions
  15. Entity Framework. Delete all rows in table
  16. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  17. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  18. Order by dynamic parameter
  19. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  20. Dynamic table name in linq [duplicate]
  21. Linq Syntax – Selecting multiple columns
  22. Join and Include in Entity Framework
  23. Linq to Entity Join table with multiple OR conditions
  24. Creating dynamic queries with entity framework
  25. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  26. Log Queries executed by Entity Framework DbContext
  27. Remove item from list based on condition
  28. How to group by DateTime.Date in EntityFramework
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment