using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Runtime.Serialization.Formatters;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

using Newtonsoft.Json;

using Newtonsoft.Json.Linq;

using Newtonsoft.Json.Converters;

using Newtonsoft.Json.Serialization;    

​

using NUnit.Framework; // Throws NUnit.Framework.AssertionException

​

//https://stackoverflow.com/questions/65430927/how-to-convert-json-data-to-datatable

​

    public class DataRoot<T>

    {

        public T Data { get; set; }

        public bool Success { get; set; }

    }

​

    class TestClass

    {

        public static void Test()

        {

            Test1();

            Test2();

        }

​

        public static void Test1()

        {

            var result = GetJson();

            var root = JsonConvert.DeserializeAnonymousType(result, new { Data = default(DataTable), Success = default(bool) });

            var gdata = root?.Data;

            var success = root?.Success ?? false;

​

            Console.WriteLine("Success = {0}", success);

            Console.WriteLine("gdata: ");

            Console.WriteLine(JsonConvert.SerializeObject(gdata, Formatting.Indented));

​

            Assert.AreEqual(3, gdata.Rows.Count);

        }   

        public static void Test2()

        {

            var result = GetJson();

            var root = JsonConvert.DeserializeObject<DataRoot<DataTable>>(result);

            var gdata = root?.Data;

            bool success = root?.Success ?? false;

​

            Console.WriteLine("Success = {0}", success);

            Console.WriteLine("gdata: ");

            Console.WriteLine(JsonConvert.SerializeObject(gdata, Formatting.Indented));

            Assert.AreEqual(3, gdata.Rows.Count);

        }

        static string GetJson()

        {

            return @"{

""Data"":[

    {

        ""Customer"":""C1"",

        ""ID"":""11111"",

        ""Desc"":""Row 1"",

        ""Price"":""123456""

    },

    {

        ""Customer"":""C2"",

        ""ID"":""22222"",

        ""Desc"":""Row 2"",

        ""Price"":""789012""

    },

    {

        ""Customer"":""C3"",

        ""ID"":""33333"",

        ""Desc"":""Row 3"",

        ""Price"":""345678""

    }

],

""Success"":true

}

";

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("Environment version: {0} ({1})", System.Runtime.InteropServices.RuntimeInformation.FrameworkDescription , GetNetCoreVersion());

            Console.WriteLine("{0} version: {1}", typeof(JsonSerializer).Assembly.GetName().Name,  typeof(JsonSerializer).Assembly.FullName);

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

                Console.WriteLine("Failed with unhandled exception: ");

                Console.WriteLine(ex);

                throw;

            }

        }

        public static string GetNetCoreVersion()

        {

            //https://techblog.dorogin.com/how-to-detect-net-core-version-in-runtime-ecd65ad695be

            //

            var assembly = typeof(System.Runtime.GCSettings).GetTypeInfo().Assembly;

            var assemblyPath = assembly.Location.Split(new[] { '/', '\\' }, StringSplitOptions.RemoveEmptyEntries);

            int netCoreAppIndex = Array.IndexOf(assemblyPath, "Microsoft.NETCore.App");

            if (netCoreAppIndex > 0 && netCoreAppIndex < assemblyPath.Length - 2)

                return assemblyPath[netCoreAppIndex + 1];

            return null;

        }

    }

​