How can I sort by multiple fields in LINQ?

Question

how can I do multiple sort in

 return (from p in _db.Pages where p.int_PostStatusId == 2 select p).OrderByDescending(m => m.int_SortOrder);

i want to do order by by int_PageId as well? first by int_SortOrder then by int_PageId

Mark Byers · Accepted Answer · 2011-01-15 14:42:21Z

14

Use either ThenBy or ThenByDescending to order the result of an OrderBy or OrderByDescending:

return (...)
    .OrderByDescending(m => m.int_SortOrder)
    .ThenBy(m => m.int_PageId);

Or using the query syntax:

orderby p.int_SortOrder descending, p.int_PageId

answered Jan 15, 2011 at 14:26

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1