C# linq groupby包含json

using System;
using System.Collections.Generic;
using System.Linq;
using Newtonsoft.Json;

public class Item
{
    public string Category { get; set; }
    public int Value { get; set; }
}

public class Program
{
    public static void Main()
    {
        // 假设这是从某处获取的JSON字符串
        string json = "[{\"Category\":\"A\",\"Value\":10},{\"Category\":\"B\",\"Value\":20},{\"Category\":\"A\",\"Value\":30}]";
        
        // 将JSON字符串反序列化为Item对象列表
        List<Item> items = JsonConvert.DeserializeObject<List<Item>>(json);
        
        // 使用LINQ进行分组
        var groupedItems = items.GroupBy(item => item.Category)
                                .Select(group => new { Category = group.Key, TotalValue = group.Sum(item => item.Value) });
        
        // 输出分组结果
        foreach (var group in groupedItems)
        {
            Console.WriteLine($"Category: {group.Category}, Total Value: {group.TotalValue}");
        }
    }
}

var groupedItems = items.AsParallel()
                        .GroupBy(item => item.Category)
                        .Select(group => new { Category = group.Key, TotalValue = group.Sum(item => item.Value) });