Multiple “order by” in LINQ(转载)

时间:2021-06-13 08:24:32

问:


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 two has 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 })

答:


This should work for you:

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

原文链接