linq multiple order DESCENDING

Question

.OrderBy(y => y.Year).ThenBy(m => m.Month);

How to set descending order?

EDIT:

I tried this:

var result = (from dn in db.DealNotes
                         where dn.DealID == dealID                         
                         group dn by new { month = dn.Date.Month, year = dn.Date.Year } into date
                         orderby date.Key.year descending
                         orderby date.Key.month descending
                         select new DealNoteDateListView { 
                             DisplayDate = date.Key.month + "-" + date.Key.year,
                             Month = date.Key.month,
                             Year = date.Key.year,
                             Count = date.Count()
                         })
                         //.OrderBy(y => y.Year).ThenBy(m => m.Month)
                         ;

And it seems working. Is it wrong to use orderby twice like I used it here?

Answer 1

You can get the descending ordering by using a different pair of methods:

items.OrderByDescending(y => y.Year).ThenByDescending(m => m.Month); 

Using LINQ query, you can write:

from date in db.Dates
orderby date.Key.year descending, date.Key.month descending 
select new { ... } 

The trick is that you need only one orderby clause - if you add multiple of these, the list will be re-sorted each time. To sort elements that have the first key equal using another key, you need to separate them using , (orderby is translated to OrderBy or OrderByDescending while , is translated to ThenBy or ThenByDescending).