How do I perform Date Comparison in EF query?

by

Use the class DbFunctions for trimming the time portion.

using System.Data.Entity;

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

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

More Related Contents:

  1. How to compare only date components from DateTime in EF?
  2. compare the month part with linq [closed]
  3. Convert DateTime to Date string “dd/mm/yyyy”
  4. Dynamic where clause (OR) in Linq to Entities
  5. How to create LINQ Expression Tree to select an anonymous type
  6. Linq-to-Entities Join vs GroupJoin
  7. ‘Contains()’ workaround using Linq to Entities?
  8. “A lambda expression with a statement body cannot be converted to an expression tree”
  9. Bulk-deleting in LINQ to Entities
  10. The type of one of the expressions in the join clause is incorrect in Entity Framework
  11. Entity framework left join
  12. C# – code to order by a property using the property name as a string [duplicate]
  13. LEFT JOIN in LINQ to entities?
  14. Linq to EntityFramework DateTime
  15. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  16. How to tell if an IEnumerable is subject to deferred execution?
  17. Linq to Entity Join table with multiple OR conditions
  18. How to get first record in each group using Linq
  19. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  20. String.IsNullOrWhiteSpace in LINQ Expression
  21. Dynamic query with OR conditions in Entity Framework
  22. Calling a SQL User-defined function in a LINQ query
  23. linq to entities vs linq to objects – are they the same?
  24. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  25. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  26. Only parameterless constructors and initializers are supported in LINQ to Entities message
  27. LINQ to Entities group-by failure using .date
  28. LINQ Query to Convert string to datetime
  29. Is Injection Possible through Dynamic LINQ?
  30. Datetime format Issue: String was not recognized as a valid DateTime

Leave a Comment