Datatable to query and fetch lastmodified date records using linq in C#

In addition to the Solution #1,

LINQ has OrderByDescending and Distinct methods. As you want unique records by Id, you first need to group the records by Id, apply distinct on it and then sort it.

var data = list.GroupBy(x => x.Id).Select(g => g.First()).ToList();
var datalist = data.Distinct().OrderByDescending(x => x.ModifiedDate);

This might solve your problem, give it a try!


KR

First of all, you need to covert your DataTable to an IEnumerable so that you can use linq. Then GroupBy the id column. Use the resultSelector function that's passed to the GroupBy statement to select an anonymous type that contains the most recent DateTime in the group. Use the values parameter and the OrderByDecending, Select and First statements to do this. In a lambda expression, you can reference a column field in a DataRow like this.

dr.Field<string>("id")

If you get stuck, post your code and I will try to help you.