Ordering linq query with secondary sort [duplicate]

Question

Possible Duplicate:
Multiple “order by” in LINQ

I have a list of orders and I need to order it by the date of the order and then a secondary sort by the price of the order. I'm not sure how exactly to do this since I tried orders.OrderBy(o => o.Date).OrderBy(o => o.Price), but it doesn't work. Any help is much appreciated. Thank you

its weird how many of this exact same question I've seen today. — Phillip Schmidt
– Phillip Schmidt, Commented Aug 3, 2012 at 15:23
I don't mean to be rude but I just googled Ordering linq query with secondary sort and found the answer on the first page to a SO post. — Nathan
– Nathan, Commented Aug 3, 2012 at 15:25
actually, its a duplicate of this, this, this, this,this,this, etc — Phillip Schmidt
– Phillip Schmidt, Commented Aug 3, 2012 at 15:27
Sorry, I'm new to this site... tried to find it but I missed it. Thanks. — Shane
– Shane, Commented Aug 3, 2012 at 16:47

FAtBalloon · Accepted Answer · 2012-08-03 15:21:50Z

35

You want to use the ThenBy function:

orders.OrderBy(o => o.Date).ThenBy(o => o.Price)

answered Aug 3, 2012 at 15:21

FAtBalloon

4,5102 gold badges27 silver badges33 bronze badges

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

Comments

scott.korin · Accepted Answer · 2012-08-03 17:24:04Z

3

The other option is to use the LINQ query syntax instead of the method syntax:

 List<Order> sortedOrders = from o in orders
 orderby o.Date, O.Price
 select o;

edited Aug 3, 2012 at 17:24

answered Aug 3, 2012 at 15:24

scott.korin

2,6152 gold badges26 silver badges37 bronze badges

2 Comments

Martin Sansone - MiOEE Over a year ago

If I understand correctly - the use of two fields within 'orderby' separated by a comma results in a form of grouping if the o.Date has a bunch of records of the same Date value - ordering the records O.Price ascending within the matching Date. ?

scott.korin Over a year ago

Yes, that's right. Same as the accepted answer. Just using a different syntax.

Am1rr3zA · Accepted Answer · 2012-08-03 15:23:32Z

1

You can use:

orders.OrderBy(o => o.Date).ThenBy(o => o.Price)

answered Aug 3, 2012 at 15:23

Am1rr3zA

7,46119 gold badges88 silver badges136 bronze badges

Collectives™ on Stack Overflow

Ordering linq query with secondary sort [duplicate]

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related