using System;

using System.Collections.Generic;

using System.Linq;

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

public class Program

{

    public static void Main()

    {

        string json = @"

            {

              ""name"": ""Customer Table"",

              ""Table"": {

                ""name"": {

                  ""id"": ""name"",

                  ""type"": ""info"",

                  ""description"": ""Customer table info""

                },

                ""RowId-123"": {

                  ""id"": ""RowId-123"",

                  ""type"": ""Row"",

                  ""children"": [

                    ""ColumnId-367""

                  ],

                  ""index"": 1,

                  ""parentId"": ""custom""

                },

                ""ColumnId-367"": {

                  ""id"": ""ColumnId-367"",

                  ""type"": ""Column"",

                  ""children"": [],

                  ""parentId"": ""RowId-123""

                },

                ""RowId-476"": {

                  ""id"": ""RowId-476"",

                  ""type"": ""Row"",

                  ""components"": [

                    ""ColumnId-317"",

                    ""ColumnId-327""

                  ],

                  ""index"": 2,

                  ""parentId"": ""custom""

                },

                ""ColumnId-317"": {

                  ""id"": ""ColumnId-317"",

                  ""type"": ""Column"",

                  ""components"": [],

                  ""index"": 0,

                  ""parentId"": ""RowId-476""

                },

                ""ColumnId-327"": {

                  ""id"": ""ColumnId-327"",

                  ""type"": ""Column"",

                  ""components"": [],

                  ""index"": 1,

                  ""parentId"": ""RowId-476""

                },

                ""TextContent12"": {

                  ""id"": ""TextContent12"",

                  ""type"": ""Text"",

                  ""index"": 0,

                  ""parentId"": ""custom""

                }

              }

            }";

        Root root = JsonConvert.DeserializeObject<Root>(json);

​

        // Get all objects at the top level (parentId is "custom") ordered by index

        var top = root.Table.item.Values

            .Where(x => x["parentId"].Value<string>() == "custom")

            .OrderBy(i => i["index"]);

​

        // Loop through top level items 

        foreach (JToken item in top)

        {

            Console.WriteLine("Index " + item["index"] + " Content:");

            Console.WriteLine(item.ToString());  // output item JSON - could be Row or something else 

​

            // Check whether the current item is a Row

            if (item["type"].Value<string>() == "Row")

            {

                // If so, get all items which have this row as a parent ordered by index

                var children = root.Table.item.Values

                    .Where(x => x["parentId"].Value<string>() == item["id"].Value<string>())

                    .OrderBy(i => i["index"]);

​

                // loop through the child items

                foreach (JToken child in children)

                {

                    Console.WriteLine(child.ToString());  // output child JSON

                }

            }

​

            Console.WriteLine();

        }

    }

}

​

public class Root

{

    public string name { get; set; }

    public string description { get; set; }

    public Table Table { get; set; }

}

public class Table

{

    public Name name { get; set; }

    [JsonExtensionData]

    public Dictionary<string, JToken> item { get; set; }

}

public class Name

{

    public string id { get; set; }

    public string type { get; set; }

    public string description { get; set; }

}

​