linq where and after that ordeby in two sql calls or one? code example
Example: c# linq order by multiple columns
var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name)
var movies = _db.Movies.OrderBy(c => c.Category).ThenBy(n => n.Name)