using System;

using System.Collections.Generic;

using System.Linq;

using Newtonsoft.Json.Linq;

public class Program

{

    public static void Main()

    {

        string json = @"

            {

                ""Columns"": [

                    {

                        ""id"": 1,

                        ""name"": ""column name 1"",

                        ""other stuff"": ""blah blah""

                    },

                    {

                        ""id"": 2,

                        ""name"": ""column name 2"",

                        ""other stuff"": ""blah blah""

                    },

                    {

                        ""id"": 3,

                        ""name"": ""column name 3"",

                        ""other stuff"": ""blah blah""

                    }

                ],

                ""Data"": [

                    [

                        ""blah bla"",

                        ""bloop"",

                        1

                    ],

                    [

                        ""t"",

                        ""another random value"",

                        5

                    ],

                    [

                        ""foo"",

                        ""bar"",

                        5

                    ],

                    [

                        ""something valuable"",

                        ""value2"",

                        5

                    ]

                ]

            }";

        JObject jo = JObject.Parse(json);

        List<Row> rows = jo["Data"]

            .Children<JArray>()

            .Select(ja => new Row

                    {

                        ColumnName1 = (string)ja[0],

                        ColumnName2 = (string)ja[1],

                        ColumnName3 = (int)ja[2]

                    })

            .ToList();

        foreach (Row row in rows)

        {

            Console.WriteLine("ColumnName1: " + row.ColumnName1);

            Console.WriteLine("ColumnName2: " + row.ColumnName2);

            Console.WriteLine("ColumnName3: " + row.ColumnName3);

            Console.WriteLine();

        }

    }

}

​

public class Row

{

    public string ColumnName1 { get; set; }

    public string ColumnName2 { get; set; }

    public int ColumnName3 { get; set; }

}

​