Linq order by, group by and order by each group?

by

Sure:

var query = grades.GroupBy(student => student.Name)
                  .Select(group => 
                        new { Name = group.Key,
                              Students = group.OrderByDescending(x => x.Grade) })
                  .OrderBy(group => group.Students.First().Grade);

Note that you can get away with just taking the first grade within each group after ordering, because you already know the first entry will be have the highest grade.

Then you could display them with:

foreach (var group in query)
{
    Console.WriteLine("Group: {0}", group.Name);
    foreach (var student in group.Students)
    {
        Console.WriteLine("  {0}", student.Grade);
    }
}

More Related Contents:

  1. Group by in LINQ
  2. Group By Multiple Columns
  3. LINQ with groupby and count
  4. C# Linq Group By on multiple columns [duplicate]
  5. Use own IComparer with Linq OrderBy
  6. LINQ Grouping dynamically
  7. LINQ Orderby Descending Query
  8. Client side GroupBy is not supported
  9. LINQ: combining join and group by
  10. LINQ Group By Multiple fields -Syntax help
  11. ILookup vs. IGrouping
  12. linq distinct or group by multiple properties
  13. Group by variable integer range using Linq
  14. LINQ to Entities group-by failure using .date
  15. LINQ query on a DataTable
  16. Deserializing JSON to .NET object using Newtonsoft (or LINQ to JSON maybe?)
  17. Select parsed int, if string was parseable to int
  18. What is the point of Lookup?
  19. An expression tree lambda may not contain a null propagating operator
  20. LINQ aggregate and group by periods of time
  21. VB.NET equivalent to C# var keyword [duplicate]
  22. Create Items from 3 collections using Linq
  23. How to get duplicate items from a list using LINQ? [duplicate]
  24. Max or Default?
  25. How to check for nulls in a deep lambda expression? [duplicate]
  26. What does LINQ return when the results are empty
  27. How do I do a left outer join with Dynamic Linq?
  28. LINQ performance FAQ
  29. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  30. LINQ: differences between single Where with multiple conditions and consecutive Wheres with single condition [duplicate]

Leave a Comment