Multiple "order by" in LINQ

Question

I have two tables, movies and categories, and I want to 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 1

This should work for you:

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

Answer 2

Using non-lambda, query-syntax LINQ, you can do this:

var movies = from row in _db.Movies               orderby row.Category, row.Name              select row; 

[EDIT to address comment] To control the sort order, use the keywords ascending (which is the default and therefore not particularly useful) or descending, like so:

var movies = from row in _db.Movies               orderby row.Category descending, row.Name              select row;