Entity Framework select one of each group by date

by

If you want to get the whole Posts. You can try this:

var query = Posts.GroupBy(p => p.Type)
                  .Select(g => g.OrderByDescending(p => p.Date)
                                .FirstOrDefault()
                   )

More Related Contents:

  1. Linq: help me to make this work
  2. Dynamic where clause (OR) in Linq to Entities
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. Bulk-deleting in LINQ to Entities
  5. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. Entity framework left join
  8. Why doesn’t Include have any effect?
  9. LEFT JOIN in LINQ to entities?
  10. Linq to EntityFramework DateTime
  11. LINQ to SQL multiple tables left outer join
  12. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  13. How to compare only date components from DateTime in EF?
  14. How to Bulk Update records in Entity Framework?
  15. Entity Framework 6 Code First Custom Functions
  16. Entity Framework. Delete all rows in table
  17. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  18. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  19. Order by dynamic parameter
  20. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  21. Linq Syntax – Selecting multiple columns
  22. Linq to Entity Join table with multiple OR conditions
  23. Export Model to DataTable
  24. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  25. Log Queries executed by Entity Framework DbContext
  26. Check if list contains item from other list in EntityFramework
  27. How to do an “in” query in entity framework?
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment