How to select only the records with the highest date in LINQ

by

If you just want the last date for each account, you’d use this:

var q = from n in table
        group n by n.AccountId into g
        select new {AccountId = g.Key, Date = g.Max(t=>t.Date)};

If you want the whole record:

var q = from n in table
        group n by n.AccountId into g
        select g.OrderByDescending(t=>t.Date).FirstOrDefault();

More Related Contents:

  1. LINQ – Left Join, Group By, and Count
  2. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  3. LINQ Where Ignore Accentuation and Case
  4. Operation could destabilize the runtime?
  5. DISTINCT() and ORDERBY issue
  6. Max or Default?
  7. How do I do a left outer join with Dynamic Linq?
  8. Get sum of two columns in one LINQ query
  9. Last and LastOrDefault not supported
  10. Linq where column == (null reference) not the same as column == null
  11. When to use Cast() and Oftype() in Linq
  12. How to get index using LINQ? [duplicate]
  13. How can I conditionally apply a Linq operator?
  14. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  15. Entity Framework/Linq EXpression converting from string to int
  16. How to flatten nested objects with linq expression
  17. Get SQL query from LINQ to SQL?
  18. How to write Asynchronous LINQ query?
  19. How do you perform a CROSS JOIN with LINQ to SQL?
  20. Difference between Lookup() and Dictionary(Of list())
  21. How to convert an expression tree to a partial SQL query?
  22. Apply function to all elements of collection through LINQ [duplicate]
  23. Enumerating through an object’s properties (string) in C#
  24. Is the Linq Count() faster or slower than List.Count or Array.Length?
  25. Intersect LINQ query
  26. LINQ – Query syntax vs method chains & lambda [closed]
  27. Resolving extension methods/LINQ ambiguity
  28. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  29. LINQ query to return a Dictionary
  30. How to include() nested child entity in linq

Leave a Comment