How to group by DateTime.Date in EntityFramework

by

Well, according to this MSDN document, Date property is supported by LINQ to SQL and I’d assume that Entity Framework supports it as well.

Anyway, try this query (notice that I’m using TruncateTime method in order to avoid resolving the date repeatedly):

var result = from device in
                 (
                     from d in DevicesRepository.GetAll()
                     select new 
                     { 
                         Device = d, 
                         AddedDate = EntityFunctions.TruncateTime(d.Added) 
                     }
                 )
             orderby device.AddedDate
             group device by device.AddedDate into g
             select new
             {
                 Date = g.Key,
                 Count = g.Count()
             };

Hope this helps.

More Related Contents:

  1. Entity Framework 6 Code First Custom Functions
  2. Log Queries executed by Entity Framework DbContext
  3. Linq: help me to make this work
  4. Entity Framework Provider type could not be loaded?
  5. How to update record using Entity Framework 6?
  6. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  7. The type of one of the expressions in the join clause is incorrect in Entity Framework
  8. Entity framework left join
  9. LEFT JOIN in LINQ to entities?
  10. Entity Framework 6 GUID as primary key: Cannot insert the value NULL into column ‘Id’, table ‘FileStore’; column does not allow nulls
  11. Linq to EntityFramework DateTime
  12. LINQ to SQL multiple tables left outer join
  13. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  14. Setting unique Constraint with fluent API?
  15. Lazy Loading vs Eager Loading
  16. How to compare only date components from DateTime in EF?
  17. How to Bulk Update records in Entity Framework?
  18. Entity Framework. Delete all rows in table
  19. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  20. Order by dynamic parameter
  21. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  22. Problems using Entity Framework 6 and SQLite
  23. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  24. Database.BeginTransaction vs Transactions.TransactionScope [duplicate]
  25. Linq Syntax – Selecting multiple columns
  26. Configure multiple database Entity Framework 6
  27. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  28. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  29. How to use String property as primary key in Entity Framework
  30. How does the SQLite Entity Framework 6 provider handle Guids?

Leave a Comment