Sorting list with linq by multiple parameters

Question

How would I sort this table rows by following order using linq orderby function:

first by Business type == A01 - Production
second by Business type == A06 - External trade without explicit capacity, where In Area == ME, Out Area by alphabet
third by Business type == A06 - External trade without explicit capacity, where Out Area == ME, In Area by alphabet
fourth by Business type == A02 - Internal trade
fifth by Business type == A04 - Consumption

enter image description here

You should try something, and also give us the model. What do mean by where In Area == ME, Out Area by alphabet ? — Ahmed KRAIEM
– Ahmed KRAIEM, Commented Oct 29, 2013 at 10:26
@AhmedKRAIEM it means that items with same A06 - External trade without explicit capacity are sorted also by area — Sergey Berezovskiy
– Sergey Berezovskiy, Commented Oct 29, 2013 at 10:29
In Your case for multiple order you should use Orderby(condition).ThenBy(condition); — Jack
– Jack, Commented Oct 29, 2013 at 10:30

Sergey Berezovskiy · Accepted Answer · 2013-10-29 11:10:32Z

1

Actually it is possible to create single query without unions:

var query = 
   db.Foos
     .OrderBy(f =>
         f.BusinessType == "A01 - Production" ? 0 :
         f.BusinessType == "A06 - External trade without explicit capacity" ?
           (f.InArea == "ME" ? 1 : (f.OutArea == "ME" ? 2 : 6)) :
         f.BusinessType == "A02 - Internal trade" ? 3 :
         f.BusinessType == "A04 - Consumption" ? 4 : 5)
     .ThenBy(f =>
         f.BusinessType == "A06 - External trade without explicit capacity" ?
             (f.InArea == "ME" ? f.OutArea : 
             (f.OutArea == "ME" ? f.InArea : ""))  : "");

If you are using Linq to Objects, then simply provide custom comparer, or override Equals and GetHashCode of your objects.

edited Oct 29, 2013 at 11:10

answered Oct 29, 2013 at 11:04

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Comments

Sergey Berezovskiy · Accepted Answer · 2013-10-29 10:47:20Z

1

I guess that this is what you want to do:

var result = 
  input.Where(e => e.BusinessType == "A01 - Production")
       .Concat(input.Where(e => e.BusinessType == "A06 - External trade without explicit capacity" && e.InArea == "ME")
                    .OrderBy(e => e.OutArea))
       .Concat(input.Where(e => e.BusinessType == "A06 - External trade without explicit capacity" && e.OutArea == "ME")
                    .OrderBy(e => e.InArea))
       .Concat(input.Where(e => e.BusinessType == "A02 - Internal trade"))
       .Concat(input.Where(e => e.BusinessType == "A04 - Consumption"));

edited Oct 29, 2013 at 10:47

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

answered Oct 29, 2013 at 10:30

Ahmed KRAIEM

10.4k4 gold badges32 silver badges33 bronze badges

Collectives™ on Stack Overflow

Sorting list with linq by multiple parameters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related