How to use orderby with 2 fields in linq

Question

Say I have these values in a database table  id   1 StartDate   1 3 2010 EndDate    1 3 2010  id   2 StartDate   1 3 2010 EndDate   1 9 2010   Now I have so far this orderby for my linq  var hold   MyList OrderBy x   gt  x StartDate  ToList      I want to order it however also using the end date   Like so the order I would want this in as  id 2 id 1   So endDates that are greater go first  I am not sure if I need to change this to use some compare function or something

User · Accepted Answer

MyList OrderBy x   gt  x StartDate  ThenByDescending x   gt  x EndDate

User · Answer

VB NET   MyList OrderBy Function f  f StartDate  ThenByDescending Function f  f EndDate    OR    From l In MyList Order By l StartDate Ascending  l EndDate Descending

User · Answer

MyList OrderBy x   gt  x StartDate  ThenByDescending x   gt  x EndDate     Note that you can use as well the Descending keyword in the OrderBy  in case you need   So another possible answer is   MyList OrderByDescending x   gt  x StartDate  ThenByDescending x   gt  x EndDate

User · Answer

Use ThenByDescending   var hold   MyList OrderBy x   gt  x StartDate                    ThenByDescending x   gt  x EndDate                    ToList      You can also use query syntax and say   var hold    from x in MyList            orderby x StartDate  x EndDate descending            select x  ToList      ThenByDescending is an extension method on IOrderedEnumerable which is what is returned by OrderBy  See also the related method ThenBy

User · Answer

If you have two or more field to order try this   var soterdList   initialList OrderBy x   gt  x Priority                                       ThenBy x   gt  x ArrivalDate                                       ThenBy x   gt  x ShipDate     You can add other fields with clasole  ThenBy

[c#] How to use orderby with 2 fields in linq?

Examples related to c#

Examples related to linq