.NET IQueryable OrderBy Aggregated Field

Question

Is there any way to perform an OrderBy with an aggregated field (string.Join)?

var query = <Some IQueryable<T>>;
    
query = query.OrderBy(x => string.Join(",", x.Values.Select(v => v.Name)));

I am building dynamic queries and came up a need to order by a column that is agreggated like the above example.

Thanks in advance

https://stackoverflow.com/questions/298725/multiple-order-by-in-linq — insane_developer, Oct 07 '20 at 17:21

score 0 · Answer 1 · answered Oct 08 '20 at 19:10

0

You need to first project the aggregated column before you can do OrderBy.


    query = query.Select(x=>new {
    Item = x,
    Agg = x => string.Join(",", x.Values.Select(v => v.Name))
    }).OrderBy(a=>a.Agg).Select(a=>a.Item)

answered Oct 08 '20 at 19:10

Ayush Jain

57
2

.NET IQueryable OrderBy Aggregated Field

1 Answers1