‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

by

If you are using EF 6.0+, you can use DbFunctions.TruncateTime(DateTime?) :

var query =
    from t in context.Logs
    where t.Title == title 
    && DbFunctions.TruncateTime(t.Timestamp) == LogDate.Date
    select t;

Note: For earlier version of EF where DbFunctions isn’t available, EntityFunctions.TruncateTime(DateTime?) can be used instead.

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. ‘Contains()’ workaround using Linq to Entities?
  4. “A lambda expression with a statement body cannot be converted to an expression tree”
  5. Bulk-deleting in LINQ to Entities
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. LEFT JOIN in LINQ to entities?
  9. How to compare only date components from DateTime in EF?
  10. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  11. Linq to Entity Join table with multiple OR conditions
  12. Dynamic query with OR conditions in Entity Framework
  13. Calling a SQL User-defined function in a LINQ query
  14. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  15. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  16. The cast to value type ‘Int32’ failed because the materialized value is null
  17. Recursive Hierarchy – Recursive Query using Linq
  18. Filter/Search using Multiple Fields – ASP.NET MVC
  19. How to do a Bulk Insert — Linq to Entities
  20. Entity Framework. Delete all rows in table
  21. Entity-framework code is slow when using Include() many times
  22. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  23. The operation cannot be completed because the DbContext has been disposed using MVC 4
  24. Export Model to DataTable
  25. Simulating Cross Context Joins–LINQ/C#
  26. Max return value if empty query
  27. Check if list contains item from other list in EntityFramework
  28. How to do an “in” query in entity framework?
  29. big issue in converting string to datetime using linq-to-entities
  30. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception

Leave a Comment