How do I get the MAX row with a GROUP BY in LINQ query

Question

I am looking for a way in LINQ to match the follow SQL Query   Select max uid  as uid  Serial Number from Table Group BY Serial Number   Really looking for some help on this one   The above query gets the max uid of each Serial Number because of the Group By Syntax

User · Answer

This can be done using GroupBy and SelectMany in LINQ lamda expression var groupByMax   list GroupBy x  gt x item1  SelectMany y  gt y Where z  gt z item2    y Max i  gt i item2

User · Answer

var q   from s in db Serials         group s by s Serial Number into g         select new  Serial Number   g Key  MaxUid   g Max s   gt  s uid

User · Answer

The answers are OK if you only require those two fields  but for a more complex object  maybe this approach could be useful   from x in db Serials  group x by x Serial Number into g  orderby g Key  select g OrderByDescending z   gt  z uid   FirstOrDefault         this will avoid the  select new

User · Answer

using  DataContext dc   new DataContext                          var q   from t in dc TableTests                     group t by t SerialNumber                         into g                         select new                                                       SerialNumber   g Key                              uid    from t2 in g select t2 uid  Max

User · Answer

I ve checked DamienG s answer in LinqPad  Instead of    g Group Max s   gt  s uid    should be  g Max s   gt  s uid    Thank you

User · Answer

In methods chain form   db Serials GroupBy i   gt  i Serial Number  Select g   gt  new               Serial Number   g Key          uid   g Max row   gt  row uid

[.net] How do I get the MAX row with a GROUP BY in LINQ query?

Examples related to .net

Examples related to linq

Examples related to linq-to-sql