LINQ Multiple order by when not using lambda expressions [duplicate]

Question

Possible Duplicate:
Multiple “order by” in LINQ

I want to order some dataset by some field AND THEN some other field.

Using lambda expressions this would be easy (OrderBy.ThenBy), but how to do it when I have a syntax like this:

 int maxQueries = int.MaxValue;
        // finds the most search for queries
        var ordered = from p in searchLogs
        where !string.IsNullOrEmpty(p.SearchQuery)
        group p by new 
        { 
           SearchQuery = p.SearchQuery
        } 
        into pgroup
        let count = pgroup.Count()
        orderby count descending
        select new 
        { 
            Count = count, 
            SearchQuery = pgroup.Key.SearchQuery
        };

I can't seem to find a way which works after the decending keyword (like orderby count descending then searchquery)..

Any ideas?

mlorbetske · Accepted Answer · 2012-12-22 12:56:57Z

7

Put a comma after descending and specify the next thing to sort by (optionally adding descending) and so on

answered Dec 22, 2012 at 12:56

mlorbetske

5,6592 gold badges32 silver badges41 bronze badges

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

Comments

Thomas C. G. de Vilhena · Accepted Answer · 2012-12-22 13:26:26Z

0

Just to add some code to mlorbetske answer, if you have Customer class like this:

public class Customer
{
    public string Name;
    public DateTime MemberSince;
}

You could then perform an ordering like this:

var q = from c in Customers
        orderby c.MemberSince.Date descending, c.Name
        select c;

answered Dec 22, 2012 at 13:26

Thomas C. G. de Vilhena

14.7k3 gold badges58 silver badges45 bronze badges

Collectives™ on Stack Overflow

LINQ Multiple order by when not using lambda expressions [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related