Linq how to get max date time value group by

Question

Id    Name   CreatedDate 

 

1      DS300    2018-04-31 04:02:31 

2      DS301    2018-04-31 04:03:31

3      DS300    2018-04-31 04:02:40

4      DS301   2018-04-31 04:02:31

 

Based on my question i need to get 

 

3 DS300 2018-04-31 04:02:40

2 DS301 2018-04-31 04:03:31

 

these records,

 

Could you please help me

 

Answer 1

Hi,

 

Please try this

 

db.tbl_test.GroupBy(i => i.Name).Select(g => new

{

Name = g.Key,

Time = g.Max(row => row.CreateDate)

});

 

Thanks & Regards

Rajendra Singh 

Answer 2

Hi,

 

Is CreatedDate is datetime in database or varchar???

 

As i inserted data in db and getting desired result .

 

Please check again.

 

Thanks

 

Answer 3

Hi,

 

if we use that query we will get based on date

I would like to know how to get based on datetime