Selecting earliest date using linq/lambda

Question

I have following expression

 var list = techlinks.GetItems().Where(p =>  p.Status == 1).ToList();

I want to change this so that I want to select the earliest date value for example

 var list = techlinks.GetItems().Where(p =>p.Date is earliest && p.Status == 1).ToList();

Please let me know what to insert for p.Date is earliest

Thanks

Answer 1

Here's another way.

var list=techlinks.GetItems()
                  .Where(p=> p.Status==1)
                    .Min(d => d.Date)
                      .Single();

Answer 2

you can use OrderBy or OrderByDescending() to sort them on Date this way:

var list = techlinks.GetItems()
                    .Where(p => p.Status == 1)
                    .OrderBy(x=>x.Date).First(); // this will give oldest date

and:

var list = techlinks.GetItems()
                    .Where(p => p.Status == 1)
                    .OrderByDescending(x=>x.Date).First(); // this will give latest date

Answer 3

Student student = _context.Set<Student>()
          .Where(p => p.StudentID == ID.Value)
          .OrderBy(p => p.AddedDate)
          .FirstOrDefault();

Answer 4

If there might be multiple items all with the earliest date:

var list = techlinks.GetItems()
    .Where(p => p.Status == 1)
    .OrderBy(x=>x.Date)
    .GroupBy(x => x.Date)
    .First()
    .ToList()