linq: multiple order by

Question

i have table movies and categories, i what get ordered list by categoryID first and then by Name

movie table has columns: ID, Name, CategoryID category table has: ID, Name

tried something like this but doesnt 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

include System.Linq; :)

Answer 3

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

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

Answer 4

great simple answer Scott Stafford, thanks