Linq – Top value from each group

by

My answer is similar to Yuriy’s, but using MaxBy from MoreLINQ, which doesn’t require the comparison to be done by ints:

var query = from player in players
            group player by player.TeamName into team
            select team.MaxBy(p => p.PlayerScore);

foreach (Player player in query)
{
    Console.WriteLine("{0}: {1} ({2})",
        player.TeamName,
        player.PlayerName,
        player.PlayerScore);
}

Note that I’ve changed the type name from “Team” to “Player” as I believe it makes more sense – you don’t start off with a collection of teams, you start off with a collection of players.

More Related Contents:

  1. Linq – Where().Where() is AND or OR?
  2. System.Linq.Expression.Compile error
  3. How to LINQ List and flatten it using SelectMany?
  4. Get All instead of FirstOrDefault
  5. Retrieving Property name from lambda expression
  6. Combining two expressions (Expression)
  7. Join/Where with LINQ and Lambda
  8. How to perform Join between multiple tables in LINQ lambda
  9. How can I get every nth item from a List?
  10. How do I invoke an extension method using reflection?
  11. Mutating the expression tree of a predicate to target another type
  12. Can I specify my explicit type comparator inline?
  13. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  14. Multiple Order By with LINQ [duplicate]
  15. How to convert an expression tree to a partial SQL query?
  16. lambda expressions in immediate window for VS2015
  17. C# Pass Lambda Expression as Method Parameter
  18. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  19. Cannot convert lambda expression to type ‘string’ because it is not a delegate type [duplicate]
  20. LINQ – Query syntax vs method chains & lambda [closed]
  21. LINQ identity function
  22. How to merge a list of lists with same type of items to a single list of items?
  23. LINQ Expression to return Property value?
  24. How to check for nulls in a deep lambda expression? [duplicate]
  25. String.IsNullOrWhiteSpace in LINQ Expression
  26. Access the value of a member expression
  27. Max return value if empty query
  28. How do I dynamically create an Expression predicate?
  29. Linq query or Lambda expression?
  30. Convert DataTable to Generic List in C#

Leave a Comment