在ASP.NET核心Web Api中从数据库中获取和排序数据

// 数据模型
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

// 数据访问层
public class ProductRepository
{
    private readonly DbContext _dbContext;

    public ProductRepository(DbContext dbContext)
    {
        _dbContext = dbContext;
    }

    public IEnumerable<Product> GetProducts()
    {
        return _dbContext.Set<Product>().ToList();
    }
}

// 控制器
[ApiController]
[Route("api/products")]
public class ProductsController : ControllerBase
{
    private readonly ProductRepository _productRepository;

    public ProductsController(ProductRepository productRepository)
    {
        _productRepository = productRepository;
    }

    [HttpGet]
    public IActionResult GetProducts(string sortBy)
    {
        var products = _productRepository.GetProducts();

        switch (sortBy)
        {
            case "name":
                products = products.OrderBy(p => p.Name);
                break;
            case "price":
                products = products.OrderBy(p => p.Price);
                break;
            default:
                break;
        }

        return Ok(products);
    }
}