• Linq中的OrderByDescending是怎么用来着了?
  • 发布于 2个月前
  • 98 热度
    2 评论
我在用Linq做数据查询,想要把刷选出来的成绩按高到低排序来着的,我记得的Linq中有个OrderByDescending语句可以做降序排序,但是有点忘记了,有老哥记得Linq中的降序语法的吗?
用户评论
  • 人走茶凉
  • 你可以参考下如下例子:

    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    namespace OrderOperation
    {
        public class Products
        {
            public int Id { get; set; }
            public int CategoryId { get; set; }
            public string Name { get; set; }
            public double Price { get; set; }
            public DateTime CreateTime { get; set; }
        }
        class Program
        {
            static void Main(string[] args)
            {
                // 初始化数据
                List<Products> listProduct = new List<Products>()
                {
                   new Products(){Id=1, CategoryId=1, Name="C#高级编程第10版", Price=100.67, CreateTime=DateTime.Now},
                   new Products(){Id=2, CategoryId=1, Name="Redis开发和运维", Price=69.9, CreateTime=DateTime.Now.AddDays(-19)},
                   new Products(){Id=3, CategoryId=1, Name="ASP.NET Core", Price=57, CreateTime=DateTime.Now.AddMonths(-3)},
                   new Products(){Id=4, CategoryId=1, Name="Entity Framework 6.x", Price=97, CreateTime=DateTime.Now.AddMonths(-1)}
                };
                Console.WriteLine("方法语法");
                // 1、查询方法,返回匿名类
                var list = listProduct.OrderByDescending(p => p.CreateTime).Select(p => new { id = p.Id, ProductName = p.Name, ProductPrice = p.Price, PublishTime = p.CreateTime }).ToList();
                foreach (var item in list)
                {
                    Console.WriteLine("item:{0}", item);
                }
                Console.WriteLine("查询表达式");
                // 2、查询表达式,返回匿名类
                var listExpress = from p in listProduct orderby p.CreateTime descending select new { id = p.Id, ProductName = p.Name, ProductPrice = p.Price, PublishTime = p.CreateTime };
                foreach (var item in listExpress)
                {
                    Console.WriteLine("item:{0}", item);
                }
                Console.ReadKey();
            }
        }
    }

  • 2024/11/10 12:12:00 [ 0 ] [ 0 ] 回复