LINQ将项目列表转换为具有冗余值的行的查找

var projects = new List<Project>
{
    new Project { Name = "Project A", Category = "Category 1", Value = 100 },
    new Project { Name = "Project B", Category = "Category 2", Value = 200 },
    new Project { Name = "Project C", Category = "Category 1", Value = 150 },
    new Project { Name = "Project D", Category = "Category 2", Value = 250 }
};

var result = projects
    .GroupBy(p => p.Category)
    .Select(g => new
    {
        Category = g.Key,
        TotalValue = g.Sum(p => p.Value),
        Projects = g.ToList()
    });

foreach (var item in result)
{
    Console.WriteLine($"Category: {item.Category}");
    Console.WriteLine($"Total Value: {item.TotalValue}");
    Console.WriteLine("Projects:");
    foreach (var project in item.Projects)
    {
        Console.WriteLine($"- {project.Name}");
    }
    Console.WriteLine();
}