Loading

Get Recent Value .

how to find Recent value in linq c# .Please provide query.

2 Replies

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

Rajanikant Hawaldar6y ago
Accepted answer
int id = (from record in table orderby record.SequenceId descending select record.SequenceId).First(); https://entityframework.net/knowledge-base/33685630/linq--select-most-recent-record-of-each-group https://forums.asp.net/t/1400424.aspx?LINQ+How+To+Find+Most+Recent+Record+By+DateTime+ https://youtu.be/12mG2dXpDK0
Ajay Gohil6y ago
Hi,

You can use last function.

Example:

var LastItem = query.Last();

If You think there is a chance your table may be empty ,use LastOrDefault().This will return null if nothig is found.

var LastItem = query.LastOrDefault();

if( LastItem==null)
{
Table null//
}