Capturing only the top record from a LINQ query

Question

I basically have a lot of poorly designed code to do something that, I am sure, can be made much more elegant.

What I'm trying to do is grab the latest date from a database table.

var Result = 
from a in DB.Table
orderby a.Date descending
select new {Date = a};

foreach(var Row in Result)
{
LastDate = Row.Date.Date;
break;
}

Basically, there is a foreach loop that is designed to run only once. Shitty code! What is the best practice way to do the same thing?

Answer 1

var first = Result.First();

If the result set is empty, it will throw an exception; you can use FirstOrDefault (), which returns null if the result set is empty.

Answer 2

Challenge First().
For instance:

LastDate = 
    (from a in DB.Table
     orderby a.Date descending
     select a.Date
    ).First();

, FirstOrDefault(), DateTime.MinValue , .

Answer 3

var LastDate = DB.Table.OrderBy(a => a.Date).FirstOrDefault();

Answer 4

FirstOrDefault() LastOrDefault() ... ...

[] - , :)

Answer 5

Result.Take(1) Take(1) First() , First , Take IEnumerable .

Answer 6

Date , coalesce.

var LastDate = Result.FirstOrDefault()?? new Date();

Answer 7

, "" (, , linq2sql SQL MAX):

var maxdate = DB.Table.Max(a => a.Date)