How to select only the records with the highest date in LINQ

Question

I have a table   lasttraces   with the following fields   Id  AccountId  Version  DownloadNo  Date   The data looks like this   28092 15240000 1 0 7 1782 2009040004731 2009-01-20 13 10 22 000 28094 61615000 1 0 7 1782 2009040007696 2009-01-20 13 11 38 000 28095 95317000 1 0 7 1782 2009040007695 2009-01-20 13 10 18 000 28101 15240000 1 0 7 1782 2009040004740 2009-01-20 14 10 22 000 28103 61615000 1 0 7 1782 2009040007690 2009-01-20 14 11 38 000 28104 95317000 1 0 7 1782 2009040007710 2009-01-20 14 10 18 000   How can I  in LINQ nbsp to nbsp SQL  only get the last lasttrace of every AccountId  the one with the highest date

User · Answer

Go a simple way to do this  -  Created one class to hold following information   Level  number  Url  Url of the site    Go the list of sites stored on a ArrayList object   And executed following query to sort it in descending order by Level      var query   from MyClass object in objCollection      orderby object Level descending      select object   Once I got the collection sorted in descending order   I wrote following code to get the Object that comes as top row  MyClass topObject   query FirstRow lt MyClass gt      This worked like charm

User · Answer

It could be something like   var qry   from t in db Lasttraces           group t by t AccountId into g           orderby t Date           select new   g AccountId  Date   g Max e   gt  e Date

User · Answer

If you just want the last date for each account  you d use this   var q   from n in table         group n by n AccountId into g         select new  AccountId   g Key  Date   g Max t  gt t Date      If you want the whole record   var q   from n in table         group n by n AccountId into g         select g OrderByDescending t  gt t Date  FirstOrDefault

User · Answer

If you want the whole record here is a lambda way   var q    context               lasttraces               GroupBy s   gt  s AccountId                Select s   gt  s OrderByDescending x   gt  x Date  FirstOrDefault

User · Answer

If you want the whole record here is a lambda way   var q    context               lasttraces               GroupBy s   gt  s AccountId                Select s   gt  s OrderByDescending x   gt  x Date  FirstOrDefault

User · Answer

If you just want the last date for each account  you d use this   var q   from n in table         group n by n AccountId into g         select new  AccountId   g Key  Date   g Max t  gt t Date      If you want the whole record   var q   from n in table         group n by n AccountId into g         select g OrderByDescending t  gt t Date  FirstOrDefault

User · Answer

It could be something like   var qry   from t in db Lasttraces           group t by t AccountId into g           orderby t Date           select new   g AccountId  Date   g Max e   gt  e Date

User · Answer

It could be something like   var qry   from t in db Lasttraces           group t by t AccountId into g           orderby t Date           select new   g AccountId  Date   g Max e   gt  e Date

User · Answer

It could be something like   var qry   from t in db Lasttraces           group t by t AccountId into g           orderby t Date           select new   g AccountId  Date   g Max e   gt  e Date

User · Answer

Here is a simple way to do it  var lastPlayerControlCommand   this ObjectContext PlayerControlCommands                                  Where c   gt  c PlayerID    player ID                                   OrderByDescending t  gt t CreationTime                                   FirstOrDefault      Also have a look this great LINQ place - LINQ to SQL Samples

User · Answer

Go a simple way to do this  -  Created one class to hold following information   Level  number  Url  Url of the site    Go the list of sites stored on a ArrayList object   And executed following query to sort it in descending order by Level      var query   from MyClass object in objCollection      orderby object Level descending      select object   Once I got the collection sorted in descending order   I wrote following code to get the Object that comes as top row  MyClass topObject   query FirstRow lt MyClass gt      This worked like charm

User · Answer

Here is a simple way to do it  var lastPlayerControlCommand   this ObjectContext PlayerControlCommands                                  Where c   gt  c PlayerID    player ID                                   OrderByDescending t  gt t CreationTime                                   FirstOrDefault      Also have a look this great LINQ place - LINQ to SQL Samples

User · Answer

If you just want the last date for each account  you d use this   var q   from n in table         group n by n AccountId into g         select new  AccountId   g Key  Date   g Max t  gt t Date      If you want the whole record   var q   from n in table         group n by n AccountId into g         select g OrderByDescending t  gt t Date  FirstOrDefault

User · Answer

If you just want the last date for each account  you d use this   var q   from n in table         group n by n AccountId into g         select new  AccountId   g Key  Date   g Max t  gt t Date      If you want the whole record   var q   from n in table         group n by n AccountId into g         select g OrderByDescending t  gt t Date  FirstOrDefault

[c#] How to select only the records with the highest date in LINQ

Examples related to c#

Examples related to .net

Examples related to linq

Examples related to linq-to-sql