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

800,742
167
1,811
1,896

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,649
2
16
29

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

13,774
2
25
29

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,480
1
17
31

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

4 Answers4