EF Linq 中的 HAVING 子句

EF Linq 中的 HAVING 子句：优化查询结果的利器

csharp
using (var context = new MyDbContext())
{
    var query = from p in context.Products
                group p by p.Name into g
                where g.Sum(p => p.Sales) > 10000
                select new
                {
                    ProductName = g.Key,
                    TotalSales = g.Sum(p => p.Sales)
                };
    foreach (var result in query)
    {
        Console.WriteLine($"Product: {result.ProductName}, Total Sales: {result.TotalSales}");
    }
}