How to find the earliest datetime from database?

Question

How can I find out the earliest datetime or the latest datetime from database table (Example TableA(Id, Name, Email, Date))?

I am using MVC entity framework and kindly let me know if somebody knows how to implement it.

Thanks a lot for viewing my question.

Vinay Singh · Answer

Hi Sorry for previous query coded try this var dateList= objEntity.EntityTable.OrderByDescending(m=>m.Date).Select(n=>n.Date).FirstOrDefault() ;

Vinay Singh · Answer

Hi Check the below linq query var dateList= objEntity.EntityTable.OrderByDesc(m=>m.Date).Select(n=>n.Date).FirstOrDefault() ; This query will return the latest date and only the single record it will return with latest date