Linq -如何编写group by查询以获取每个产品的数量

var products = new List<Product>
{
    new Product { Id = 1, Name = "Product A", Category = "Category 1" },
    new Product { Id = 2, Name = "Product B", Category = "Category 1" },
    new Product { Id = 3, Name = "Product C", Category = "Category 2" },
    new Product { Id = 4, Name = "Product D", Category = "Category 2" },
    new Product { Id = 5, Name = "Product E", Category = "Category 2" }
};

var productCounts = products
    .GroupBy(p => p.Category) // 按照产品类别进行分组
    .Select(g => new { Category = g.Key, Count = g.Count() }); // 获取每个类别的产品数量

foreach (var productCount in productCounts)
{
    Console.WriteLine($"Category: {productCount.Category}, Count: {productCount.Count}");
}