对LINQ json结果中的多个表进行分组

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

// 假设有一个包含多个表的JSON数据
string json = @"
{
    'table1': [
        { 'id': 1, 'name': 'John' },
        { 'id': 2, 'name': 'Jane' },
        { 'id': 3, 'name': 'Bob' }
    ],
    'table2': [
        { 'id': 1, 'age': 25 },
        { 'id': 2, 'age': 30 },
        { 'id': 3, 'age': 35 }
    ]
}";

// 解析JSON数据
JObject data = JsonConvert.DeserializeObject<JObject>(json);

// 使用LINQ进行分组
var groupedData = from table1Row in data["table1"]
                  join table2Row in data["table2"] on (int)table1Row["id"] equals (int)table2Row["id"]
                  group new { table1Row, table2Row } by (string)table1Row["name"] into g
                  select new
                  {
                      Name = g.Key,
                      Rows = g.Select(x => new
                      {
                          Id = (int)x.table1Row["id"],
                          Age = (int)x.table2Row["age"]
                      })
                  };

// 输出分组结果
foreach (var group in groupedData)
{
    Console.WriteLine("Name: " + group.Name);
    foreach (var row in group.Rows)
    {
        Console.WriteLine("Id: " + row.Id + ", Age: " + row.Age);
    }
    Console.WriteLine();
}