To get maximum value of a column that contains integer, I can use the following T-SQL comand
SELECT MAX(expression ) FROM tables WHERE predicates;
Is it possible to obtain the same result with Entity Framework.
Let's say I have the following model
public class Person { public int PersonID { get; set; } public int Name { get; set; } public int Age { get; set; } }
How do I get the oldest person's age?
int maxAge = context.Persons.?
Try this int maxAge = context.Persons.Max(p => p.Age);
And make sure you have using System.Linq;
at the top of your file
If the list is empty I get an exception. This solution will take into account this issue:
int maxAge = context.Persons.Select(p => p.Age).DefaultIfEmpty(0).Max();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With