English 中文(简体)
sorting of an Iqueryable
原标题:

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

最佳回答

Try this:

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

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());




相关问题
IQueryable into a hierarchy

I currently have an IQueryable of Questions. In my Question object I have and "id" and a "parentId" which can be used to create a hierarchy. Currently, I bind a RadTreeView to the IQueryable of ...

sorting of an Iqueryable

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

Determine the position of an element in an IQueryable

I have a IQueryable which is ordered by some condition. Now I want to know the position of a particular element in that IQueryable. Is there a linq expression to get that. Say for example there are ...

Linq-Sql IQueryable<T> and chaining OR operations

I m trying to simulate: WHERE x.IsActive = true OR x.Id = 5 The following causes AND to be used... how do I simulate an OR condition with IQueryable (qry) and my nullable int, given that other ...

Linq, Where Extension Method, Lambda Expressions, and Bool s

Greetings, I am having some issues with using a bool operation within a Where clause extension method of an IQueryable object obtained using Linq to Entities. The first example is showing what does ...

Linq - How to turn IQueryable<IEnumerable> into IQueryable

I have a simple linq statement that isn t quite returning what I would like. I understand why, I just don t know how to wriet it to get what I want. The query is as follows: answers = from a in ents....

热门标签