How to find item with max value using linq?

c# linq max
user1784622 picture user1784622 · Mar 7, 2013 · Viewed 117.4k times · Source

Have a look at the below table:

Item          Value
A                10
b                50
c                90

I want to find the item with maximum value. I can get that by using group by or orderding, but somehow I have a feeling there should be a more direct way. Am I right?

Answer

Sergey Berezovskiy picture Sergey Berezovskiy · Mar 7, 2013

With EF or LINQ to SQL:

var item = db.Items.OrderByDescending(i => i.Value).FirstOrDefault();

With LINQ to Objects I suggest to use morelinq extension MaxBy (get morelinq from nuget):

var item = items.MaxBy(i => i.Value);

Related questions

How to perform .Max() on a property of all objects in a collection and return the object with maximum value

I have a list of objects that have two int properties. The list is the output of another linq query. The object: public class DimensionPair { public int Height { get; set; } public int Width { get; set; } } I want to find and …

Read More
Good way to get the key of the highest value of a Dictionary in C#

I'm trying to get the key of the maximum value in the Dictionary<string, double> results. This is what I have so far: double max = results.Max(kvp => kvp.Value); return results.Where(kvp => kvp.Value == …

Read More
Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More