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 items and they will all have the same ImportedDate.

How can I write a LINQ query that grabs only the entries with the most recent ImportedDate?

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

Answer 1

Try this:

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

If you need the latest record for each [something] like, say, for each individual customer, then make the siubquery correlated

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

Answer 2

Try This

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

Answer 3

How about this:

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

Answer 4

You can group the results and order them by date:

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

Answer 5

In fluent syntax:

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