实体框架6使用反射排序

using System;
using System.Linq;
using System.Linq.Expressions;

// 定义实体类
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

// 创建实体框架上下文
public class MyDbContext : DbContext
{
    public DbSet<Product> Products { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        using (var context = new MyDbContext())
        {
            // 获取排序属性
            var property = typeof(Product).GetProperty("Price");

            // 构建排序表达式
            var parameter = Expression.Parameter(typeof(Product), "p");
            var propertyAccess = Expression.Property(parameter, property);
            var orderByExpression = Expression.Lambda(propertyAccess, parameter);

            // 应用排序表达式
            var query = context.Products.OrderBy(orderByExpression);

            // 执行查询
            var result = query.ToList();

            // 输出结果
            foreach (var product in result)
            {
                Console.WriteLine($"{product.Id} - {product.Name} - {product.Price}");
            }
        }
    }
}