C# LINQ：动态创建属性和值，其中包括分组查询中的值之和

# 使用C# LINQ动态创建属性和值，实现分组查询中的值之和

csharp
var salesData = new List
{
    new ProductSale { ProductName = "ProductA", Category = "Category1", Amount = 100 },
    new ProductSale { ProductName = "ProductB", Category = "Category2", Amount = 150 },
    new ProductSale { ProductName = "ProductC", Category = "Category1", Amount = 200 },
    // 添加更多销售数据...
};

csharp
var groupedData = from sale in salesData
                  group sale by sale.Category into groupedSales
                  select new
                  {
                      Category = groupedSales.Key,
                      TotalAmount = groupedSales.Sum(s => s.Amount)
                  };