The specified type member ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties

by

DateTime.Date cannot be converted to SQL. Use EntityFunctions.TruncateTime method to get date part.

var eventsCustom = eventCustomRepository
.FindAllEventsCustomByUniqueStudentReference(userDevice.UniqueStudentReference)
.Where(x => EntityFunctions.TruncateTime(x.DateTimeStart) == currentDate.Date);

UPDATE: As @shankbond mentioned in comments, in Entity Framework 6 EntityFunctions is obsolete, and you should use DbFunctions class, which is shipped with Entity Framework.

More Related Contents:

  1. Convert String to Int in EF 4.0
  2. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  3. LEFT JOIN in LINQ to entities?
  4. Learning about LINQ [closed]
  5. How to create a dynamic LINQ join extension method
  6. Instantiating a context in LINQ to Entities
  7. EF 4: Removing child object from collection does not delete it – why?
  8. Linq To Entities – how to filter on child entities
  9. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  10. LINQ to Entities group-by failure using .date
  11. How to implement Unit of Work that works with EF and NHibernate
  12. LINQ to Entities does not recognize the method
  13. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  14. LINQ: Distinct values
  15. Entity Framework: There is already an open DataReader associated with this Command
  16. LINQ-to-SQL vs stored procedures? [closed]
  17. “A lambda expression with a statement body cannot be converted to an expression tree”
  18. How to view LINQ Generated SQL statements?
  19. How to view LINQ Generated SQL statements?
  20. LINQ across multiple databases
  21. Entity Framework/Linq EXpression converting from string to int
  22. How can I reject all changes in a Linq to SQL’s DataContext?
  23. Sum of items in a collection
  24. Linq To Sql – Dynamic OrderBy – Case When
  25. String.IsNullOrWhiteSpace in LINQ Expression
  26. Calling a SQL User-defined function in a LINQ query
  27. Greater Than Condition in Linq Join
  28. How do I write this cross apply query in LINQ-to-SQL?
  29. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  30. Help with Linq and Generics. Using GetValue inside a Query

Leave a Comment