Loading

How to get the MaxValue using LINQ ?!

How to get the MaxValue using LINQ ?!

Abdalla Omran

7y2.5kVisual Basic .NET

Hi there .

i am useing the following Code trying to get the maxValue from a list but it gives me an Exception (At least one object must implement IComparable) !

I need help to get a solution and explanation why this Exception

Hide Copy Code

public static TheQFromDB GetMaxWithLINQ (List input)

{

TheQFromDB GetItem = input.First();

foreach (var item in input)

{

var max = input.OrderByDescending(s=> s.SecondsDiff).Max();

GetItem = item;

}

return GetItem;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews7y ago
Accepted answer
Error is coming as you are trying to find the max value of a list of objects. MAX may use against a list of numerics. e.g. below.
List<int> list = new List<int>();
list.Add(100);
list.Add(200);
list.Add(300);
var i = list.Max();
Objects may contain numerics, strings, dates etc... as properties. So MAX won't function against a whole object list. But you can sort your object list based on a specific property of your object and then get MAX value of that specific property. like below.
//var max = input.OrderByDescending(s => s.SecondsDiff).Max(); Wrong
var max = input.OrderByDescending(s => s.SecondsDiff).First(); Correct
+1
Abdalla Omran7y ago
Jaish Mathews
I thank you a lot
it works now
+1
Manoj Bhoir7y ago
Hi,

There are many ways to find max value from the list.

As per your code below code will work for yoou.
public static TheQFromDB GetMaxWithLINQ(List input)
        {
            return input.OrderByDescending(s => s.SecondsDiff).First();
        }
Please check this link.

https://stackoverflow.com/questions/3464934/get-max-value-from-listmytype
+1