Sort collection within collection using Linq

Question

Hi, I have a one-to-many Linq query and I would like to sort on a property within the "many" collection. For example in the pseudo-code below, I am returned a List from the Linq query but I would like to sort / order the Products property based on the SequenceNumber property of the Product class. How can I do this? Any information is appreciated. Thanks.

public class Order
{
   public int OrderId;
   public List<Product> Products;
}

public class Product
{
   public string name;
   public int SequenceNumber;
}

Answer 1

Within Order, simply do

Products = Products.OrderBy(o => o.SequenceNumber);

There is also a Sort() method within List<T> to sort the list directly.

Answer 2

order.Product.OrderBy(p => p.SequenceNumber);

Answer 3

Read about order by clause.

Answer 4

As I read your question, your query returns IEnumerable<Order> and you want to sort them on SequenceNumber.

In order to sort on something, it must have one value. There are multiple SequenceNumber's because there are multiple Products. You need to decide how you will select the number to sort on.

Let's say you want to sort the orders on the largest SequenceNumber for Products on that Order. Then a query could be:

from order in orders
orderby order.Products.Max(p=>p.SequenceNumber)
select order;

Answer 5

If you want to sort the collection "in-place", just call

Products.Sort((lhs, rhs) => lhs.SequenceNumber.CompareTo(rhs.SequenceNumber));

If you want to sort the collection "on-demand", just use LINQ:

foreach (var product in order.Products.OrderBy(x => x.SequenceNumber)) {
}