sorting of an Iqueryable

Question

I have an IQueryable with duplicate entries and I want to sort this IQueryable by the count of occurrences.

Answer 1

Try this:

from e in myQueryable
group e by e.Something into g
order by g.Count()
select g  //Or, g.First()

Answer 2

Like this:

list
    .GroupBy(x => x.ID)
    .Select(x => new {Obj = x.First(), Count = x.Count()})
    .OrderBy(x => x.Count)
    .Select(x => x.Obj);

I like SLaks' solution more, though.

list
    .GroupBy(x => x.ID)          
    .OrderBy(x => x.Count())
    .Select(x => x.First());