C#数据表分组，选择并求和

using System;
using System.Collections.Generic;
using System.Linq;

class Program
{
    static void Main()
    {
        // 创建一个包含数据的数据表
        List<Person> people = new List<Person>
        {
            new Person { Name = "Alice", Age = 25, Salary = 5000 },
            new Person { Name = "Bob", Age = 30, Salary = 6000 },
            new Person { Name = "Alice", Age = 35, Salary = 7000 },
            new Person { Name = "Bob", Age = 40, Salary = 8000 },
            new Person { Name = "Alice", Age = 45, Salary = 9000 }
        };

        // 使用LINQ进行数据表的分组、选择和求和操作
        var result = from person in people
                     group person by person.Name into g
                     select new
                     {
                         Name = g.Key,
                         TotalSalary = g.Sum(p => p.Salary)
                     };

        // 输出结果
        foreach (var item in result)
        {
            Console.WriteLine($"Name: {item.Name}, Total Salary: {item.TotalSalary}");
        }
    }
}

class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
    public int Salary { get; set; }
}