HomeCSharpHow to order by multiple columns using Lambas and LINQ in C# ?

How to order by multiple columns using Lambas and LINQ in C# ?

Today , I was required to order a list of records based on a Name and then ID .

A simple one but i did spend some time on how to do it with Lambda Expression in C# .

How to order by multiple columns using Lambas and LINQ in C# ?

C# provides the OrderBy,OrderByDescending,ThenBy,ThenByDescending .

You can use them in your lambda expression to order the records as per your requirement .

Assuming your list is “Phones” and contains the following data …

public class Phone
{
        public int ID { get; set; }

        public string Name { get; set; }
}

public class Phones : List
{
        public Phones()
        {
            Add(new Phone { ID = 1, Name = "Windows Phone 7" });
            Add(new Phone { ID = 5, Name = "iPhone" });
            Add(new Phone { ID = 2, Name = "Windows Phone 7" });
            Add(new Phone { ID = 3, Name = "Windows Mobile 6.1" });
            Add(new Phone { ID = 6, Name = "Android" });
            Add(new Phone { ID = 10, Name = "BlackBerry" });
        }
}

If you were to use LINQ Query , the query will look like the one below

 dataGridView1.DataSource = (from m in new Phones()
                                        orderby m.Name, m.ID
                                        select m).ToList();

Simple isn’t it ? It very simple using Lamba expression too 🙂

Your Lambda’s expression for the above LINQ query will look like the one below

dataGridView1.DataSource = new Phones().OrderByDescending(a => a.Name).ThenByDescending(a => a.ID)
.ToList();

Share:

    1 Comment

  1. Lawrance
    January 13, 2012
    Reply

    this was very helpful. keep up the goodwork.

Leave a Reply

You May Also Like

This C# program calculates and displays an upper triangular matrix based on user input. Problem Statement: The program takes the...
This C# program serves as a demonstration of bitwise operators, which are fundamental operators used for manipulating individual bits in...
This C# program is designed to interchange or swap the columns of a matrix. A matrix is a two-dimensional array...