How to compare only date components from DateTime in EF?

by

Use the class EntityFunctions for trimming the time portion.

using System.Data.Objects;    

var bla = (from log in context.Contacts
           where EntityFunctions.TruncateTime(log.ModifiedDate) ==  EntityFunctions.TruncateTime(today.Date)
           select log).FirstOrDefault();

Source: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/84d4e18b-7545-419b-9826-53ff1a0e2a62/

UPDATE

As of EF 6.0 and later EntityFunctions is replaced by DbFunctions.

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. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  10. How do I perform Date Comparison in EF query?
  11. Linq to Entity Join table with multiple OR conditions
  12. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  13. Dynamic query with OR conditions in Entity Framework
  14. Calling a SQL User-defined function in a LINQ query
  15. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  16. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  17. The cast to value type ‘Int32’ failed because the materialized value is null
  18. The result of a query cannot be enumerated more than once
  19. How to do a Bulk Insert — Linq to Entities
  20. Entity-framework code is slow when using Include() many times
  21. The operation cannot be completed because the DbContext has been disposed using MVC 4
  22. Export Model to DataTable
  23. Simulating Cross Context Joins–LINQ/C#
  24. Max return value if empty query
  25. Check if list contains item from other list in EntityFramework
  26. How to do an “in” query in entity framework?
  27. big issue in converting string to datetime using linq-to-entities
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment