Select Where Table.Value == Maximum

Question

I have an SQL table with the following design:

TableSchedule:
Id
Description
ImportedDate

I can import a large number of elements, and all of them will have the same ImportedDate.

How can I write a LINQ query that only captures records with the latest ImportedDate?

var ResultSchedule =
    from a in Db.TableSchedule
    where a.ImportedDate == (Newest?)

Answer 1

try it

var ResultSchedule = 
from a in Db.TableSchedule 
where a.ImportedDate == (from item in DB.TableSchedule Select item.ImportedDate).Max() 

Answer 2

Try the following:

  Select * From Table
  Where ImportedDate  = 
     (Select max(ImportedDate) From Table)

If you need the last entry for each [something], for example, for each individual client, then do a siubquery correlation

  Select * From Table t
  Where ImportedDate  = 
     (Select max(ImportedDate) 
      From Table
      Where Customer = t.Customer)

Answer 3

:

var ResultSchedule = from a in Db.TableSchedule
                     let max = Db.TableSchedule.Max(i => i.ImportedDate)
                     where a.ImportedDate == max
                     select a;

Answer 4

:

var ResultsSchedule = Db.TableSchedule.
                      GroupBy(a => a.ImportedDate).
                      OrderByDescending(g => g.Key).
                      FirstOrDefault().
                      Select(g => g);

Answer 5

:

var ResultSchedule = 
    Db.TableSchedule.Where(
       a => a.ImportedDate.Equals(Db.TableSchedule.Max(b => b.ImportedDate))
    );