Loading

How to find the earliest datetime from database?

Asp.Net Hein

10y861.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
Sorry for previous query coded try this
var dateList= objEntity.EntityTable.OrderByDescending(m=>m.Date).Select(n=>n.Date).FirstOrDefault();
+1
Vinay Singh10y ago
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
+1