将MSSQL查询转换为Lambda表达式或LINQ。分组求和和排序

using System;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 模拟数据库表数据
        var data = new[]
        {
            new Product { Id = 1, Name = "Product 1", Category = "Category A", Price = 10 },
            new Product { Id = 2, Name = "Product 2", Category = "Category A", Price = 20 },
            new Product { Id = 3, Name = "Product 3", Category = "Category B", Price = 30 },
            new Product { Id = 4, Name = "Product 4", Category = "Category B", Price = 40 },
            new Product { Id = 5, Name = "Product 5", Category = "Category C", Price = 50 }
        };

        // 转换为Lambda表达式或LINQ查询
        var groupedData = data.GroupBy(x => x.Category);
        var sumData = groupedData.Select(g => new { Category = g.Key, TotalPrice = g.Sum(x => x.Price) });
        var sortedData = sumData.OrderBy(x => x.Category);

        // 输出结果
        foreach (var item in sortedData)
        {
            Console.WriteLine($"Category: {item.Category}, Total Price: {item.TotalPrice}");
        }
    }
}

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Category { get; set; }
    public decimal Price { get; set; }
}