The specified type member ‘Date’ is not supported in LINQ to Entities Exception

by

You can use the TruncateTime method of the EntityFunctions to achieve a correct translations of the Date property into SQL:

using System.Data.Objects; // you need this namespace for EntityFunctions

// ...

DateTime ruleData = Convert.ToDateTime(rule.data).Date;
return jobdescriptions
    .Where(j => EntityFunctions.TruncateTime(j.JobDeadline) == ruleData);

Update: EntityFunctionsis deprecated in EF6, Use DbFunctions.TruncateTime

More Related Contents:

  1. ASP.NET MVC 2.0 Implementation of searching in jqgrid
  2. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  3. Best way to check if object exists in Entity Framework? [closed]
  4. Entity Framework 4 / POCO – Where to start? [closed]
  5. Include Grandchildren in EF Query
  6. LINQ to Entities for subtracting 2 dates
  7. LINQ To Entities + Include + Anonymous type issue
  8. EF4 LINQ Ordering Parent and all child collections with Eager Loading (.Include())
  9. Code First: Independent associations vs. Foreign key associations?
  10. LINQ to Entities does not recognize the method
  11. Unique Key constraints for multiple columns in Entity Framework
  12. Entity Framework 6 Code first Default value
  13. “A lambda expression with a statement body cannot be converted to an expression tree”
  14. Improve navigation property names when reverse engineering a database
  15. Create a Dropdown List for MVC3 using Entity Framework (.edmx Model) & Razor Views && Insert A Database Record to Multiple Tables
  16. How to configure ProviderManifestToken for EF Code First
  17. Can I specify global mapping rules in Entity Framework Code First?
  18. The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid
  19. Entity Framework loading child collection with sort order
  20. Entity Framework 4 selective lazy loading properties
  21. Equivalent for .HasOptional in Entity Framework Core 1 (EF7)
  22. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  23. Calling a SQL User-defined function in a LINQ query
  24. Keyword not supported: “data source” initializing Entity Framework Context
  25. Entity Framework Data Annotations Set StringLength VarChar
  26. EF 4.1 loading filtered child collections not working for many-to-many
  27. How to map Table per Type (TPT) inheritance in Entity designer?
  28. Entity Framework: Inheritance and Include
  29. Entity Framework – Get List of Tables
  30. Entity framework code first delete with cascade

Leave a Comment