Multiple "order by" in LINQ
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 })