LINQ to Entities group-by failure using .date

by

Use the EntityFunctions.TruncateTime method:

var myQuery = from p in dbContext.Trends
          group p by EntityFunctions.TruncateTime(p.UpdateDateTime) into g
          select new { k = g.Key, ud = g.Max(p => p.Amount) };

More Related Contents:

  1. LEFT JOIN in LINQ to entities?
  2. Group by in LINQ
  3. Group By Multiple Columns
  4. Dynamic where clause (OR) in Linq to Entities
  5. How to create LINQ Expression Tree to select an anonymous type
  6. ‘Contains()’ workaround using Linq to Entities?
  7. “A lambda expression with a statement body cannot be converted to an expression tree”
  8. Bulk-deleting in LINQ to Entities
  9. Entity framework left join
  10. Entity Framework/Linq EXpression converting from string to int
  11. Client side GroupBy is not supported
  12. LINQ: combining join and group by
  13. The result of a query cannot be enumerated more than once
  14. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  15. linq distinct or group by multiple properties
  16. How do I perform Date Comparison in EF query?
  17. Linq to Entity Join table with multiple OR conditions
  18. How to get first record in each group using Linq
  19. Creating dynamic queries with entity framework
  20. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  21. Group by variable integer range using Linq
  22. String.Equals() not working as intended
  23. String.IsNullOrWhiteSpace in LINQ Expression
  24. Dynamic query with OR conditions in Entity Framework
  25. Calling a SQL User-defined function in a LINQ query
  26. Add the where clause dynamically in Entity Framework
  27. linq to entities vs linq to objects – are they the same?
  28. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  29. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  30. Only parameterless constructors and initializers are supported in LINQ to Entities message

Leave a Comment