max date record in LINQ

Starting from .NET 6 MaxBy LINQ method is available.

Prior to .NET 6:

O(n log n):

var result = items.OrderByDescending(i => i.Date).First();

O(n) – but iterates over the sequence twice:

var max = items.Max(i => i.Date);var result = items.First(i => i.Date == max);

Or you can use MoreLINQ which has MaxBy method which is O(n)

c# .net sql-server linq max

To get the maximum Sample value by date without having to sort (which is not really necessary to just get the maximum):

var maxSample  = Samples.Where(s => s.Date == Samples.Max(x => x.Date))                        .FirstOrDefault();

c# .net sql-server linq max

var lastInstDate = model.Max(i=>i.ScheduleDate);

We can get max date from the model like this.

CodeHunter