LINQ Using Max() to select a single row

by

I don’t see why you are grouping here.

Try this:

var maxValue = table.Max(x => x.Status)
var result = table.First(x => x.Status == maxValue);

An alternate approach that would iterate table only once would be this:

var result = table.OrderByDescending(x => x.Status).First();

This is helpful if table is an IEnumerable<T> that is not present in memory or that is calculated on the fly.

More Related Contents:

  1. Prevent duplicates from array, based on condition [closed]
  2. Linq: help me to make this work
  3. Get all checked nodes of a treeview
  4. How to flatten tree via LINQ?
  5. When to use .First and when to use .FirstOrDefault with LINQ?
  6. Using LINQ to remove elements from a List
  7. printing all contents of array in C#
  8. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  9. Convert string[] to int[] in one line of code using LINQ
  10. LINQ – Left Join, Group By, and Count
  11. Extension methods must be defined in a non-generic static class
  12. Func with out parameter
  13. LINQ: Not Any vs All Don’t
  14. C# – code to order by a property using the property name as a string [duplicate]
  15. Can I specify my explicit type comparator inline?
  16. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  17. LINQ Inner-Join vs Left-Join
  18. DISTINCT() and ORDERBY issue
  19. High memory consumption with Enumerable.Range?
  20. Can I split an IEnumerable into two by a boolean criteria without two queries?
  21. Can I LINQ a JSON?
  22. Use linq to generate direct update without select
  23. Linq – What is the quickest way to find out deferred execution or not?
  24. Remove Item in Dictionary based on Value
  25. How to sort a dictionary by key
  26. How does PredicateBuilder work
  27. Issues Doing a String Comparison in LINQ
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. Map two lists into a dictionary in C#
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment