Multiple "order by" in LINQ

linq sql-order-by
Sasha picture Sasha · Nov 18, 2008 · Viewed 628.8k times · Source

I have two tables, movies and categories, and I get an ordered list by categoryID first and then by Name.

The movie table has three columns ID, Name and CategoryID. The category table has two columns ID and Name.

I tried something like the following, but it didn't work.

var movies = _db.Movies.OrderBy( m => { m.CategoryID, m.Name })

Answer

Nathan W picture Nathan W · Nov 18, 2008

This should work for you:

var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name)

Related questions

LINQ Orderby Descending Query

I'm sure this will be a relatively simple one. I have a LINQ query that I want to order by the most recently created date. See: var itemList = from t in ctn.Items where !t.Items && t.DeliverySelection …

Read More
Linq order by, group by and order by each group?

I have an object that looks something like this: public class Student { public string Name { get; set; } public int Grade { get; set; } } I would like to create the following query: group grades by student name, order each student group by …

Read More
How can I do an OrderBy with a dynamic string parameter?

I want to do this: var orderBy = "Nome, Cognome desc"; var timb = time.Timbratures.Include("Anagrafica_Dipendente") .Where(p => p.CodDipendente == 1); if(orderBy != "") timb = timb.OrderBy(orderBy); Is there an OrderBy overload available that accepts a string parameter?

Read More