LINQ Group by字符串和count分组属性的子属性

// 假设有一个Person类，包含Name和Age属性
class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
}

// 假设有一个Person集合
List<Person> persons = new List<Person>
{
    new Person { Name = "Alice", Age = 25 },
    new Person { Name = "Bob", Age = 30 },
    new Person { Name = "Alice", Age = 35 },
    new Person { Name = "Bob", Age = 40 },
    new Person { Name = "Alice", Age = 45 }
};

// 使用LINQ查询语法进行分组和统计操作
var result = from person in persons
             group person by person.Name into g
             select new
             {
                 Name = g.Key,
                 Count = g.Count(),
                 AverageAge = g.Average(p => p.Age)
             };

// 输出结果
foreach (var item in result)
{
    Console.WriteLine($"Name: {item.Name}, Count: {item.Count}, Average Age: {item.AverageAge}");
}