.NET[C#]LINQ lambda表达式如何实现倒序排序(ORDER BY DESC)？

.NET[C#]LINQ lambda表达式如何实现倒序排序(ORDER BY DESC)？

方案一

可以使用 OrderByDescending 和 ThenByDescending来实现倒序排序，具体如下：

非 lambda LINQ 查询中：

var query = from person in people
            orderby person.Name descending, person.Age descending
            select person.Name;

lambda LINQ 查询中：

var query = people.OrderByDescending(person => person.Name)
                  .ThenByDescending(person => person.Age)
                  .Select(person => person.Name);

方案二

List<int> list = new List<int>();
list.Add(1);
list.Add(5);
list.Add(4);
list.Add(3);
list.Add(2);

foreach (var item in list.OrderByDescending(x => x))
{
    Console.WriteLine(item);                
}

方案三

var qry = Employees
          .OrderByDescending (s => s.EmpFName)
          .ThenBy (s => s.Address)
          .Select (s => s.EmpCode);