How to order a linq query result by two different types fields

Question

Possible Duplicate:
Multiple “order by” in LINQ

I wonder how to order by two different types a query like the next:

            var qry = (from m in dc.Orders
                   select new { m.OrderDate, m.OrderID }).OrderBy(o=>o.OrderDate+o.OrderID).ToList();
        bindingSource1.DataSource = qry;

OrdrerDate is a date type and OrderID is an int type.

http://msdn.microsoft.com/en-us/library/system.linq.queryable.thenby.aspx — parapura rajkumar, Aug 03 '12 at 14:35

score 6 · Accepted Answer · answered Aug 03 '12 at 14:35

6

You're looking for .ThenBy():

.OrderBy(o => o.OrderDate).ThenBy(o => o.OrderID).

answered Aug 03 '12 at 14:35

SLaks

868,454
176
1,908
1,964

Yes, that's it tank you. – Sami-L Aug 03 '12 at 14:39

score 1 · Answer 2 · answered Aug 03 '12 at 14:36

1

I would say:

 var qry = (from m in dc.Orders
                   select new { m.OrderDate, m.OrderID }).OrderBy(o=>o.OrderDate).ThenBy(o.OrderID).ToList();

answered Aug 03 '12 at 14:36

bitsmuggler

1,689
2
17
30

score 1 · Answer 3 · answered Aug 03 '12 at 14:37

1

Try this

var qry = (from m in dc.Orders 
               select new { m.OrderDate, m.OrderID }).OrderBy(o=>o.OrderDate).ThenBy(o.OrderID).ToList();

answered Aug 03 '12 at 14:37

Justin Harvey

14,446
2
27
30

score 1 · Answer 4 · answered Aug 03 '12 at 14:39

1

you can use ThenBy or you can write this Linq query :

var qry = (from m in dc.Orders
            orderby m.OrderDate, m.OrderID
    select new {m.OrderDate, m.OrderID}).ToList

        bindingSource1.DataSource = qry;

answered Aug 03 '12 at 14:39

2GDev

2,478
1
20
32

How to order a linq query result by two different types fields

4 Answers4