如何在实体框架中使用条件聚合sql查询？

// 创建实体模型
public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

// 定义查询条件
decimal minPrice = 10;
decimal maxPrice = 100;

// 执行聚合查询
decimal totalPrice = dbContext.Products
    .Where(p => p.Price >= minPrice && p.Price <= maxPrice)
    .Sum(p => p.Price);

int totalCount = dbContext.Products
    .Where(p => p.Price >= minPrice && p.Price <= maxPrice)
    .Count();

// 获取查询结果
Console.WriteLine("Total Price: " + totalPrice);
Console.WriteLine("Total Count: " + totalCount);