using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Data;

using System.ComponentModel.DataAnnotations;

using System.Globalization;

using System.Reflection;

using System.Collections.ObjectModel;

​

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

​

using CsvHelper;

using CsvHelper.Configuration;

using CsvHelper.Configuration.Attributes;

using CsvHelper.Expressions;

using CsvHelper.TypeConversion;

​

using Newtonsoft.Json;

​

//https://stackoverflow.com/questions/62797269/serialize-a-csv-to-json-with-header-record-using-json-net-newtonsoft

​

    class TestClass

    {

        public static void Test()

        {

            var refPath = "Question1050112.txt";

            var csv = @"Year,Make,Model,Length

1997,Ford,E350,2.35

2000,Mercury,Cougar,2.38

";

            File.WriteAllText(refPath, csv);

            try

            {

                var dt = CsvExtensions.LoadCsvData(refPath);

                var json = JsonConvert.SerializeObject(dt, Formatting.Indented);

                Console.WriteLine(json);

            }

            finally

            {

                File.Delete(refPath);

            }

        }   

    }

​

    public static class CsvExtensions

    {

        //https://stackoverflow.com/questions/1050112/how-to-read-a-csv-file-into-a-net-datatable

        //https://stackoverflow.com/a/59721232

        // By https://stackoverflow.com/users/11145237/youssef-bouha

​

        public static DataTable LoadCsvData(string refPath)

        {

            var cfg = new CsvHelper.Configuration.CsvConfiguration(CultureInfo.InvariantCulture) { Delimiter = ",", HasHeaderRecord = true };

            var result = new DataTable();

            using (var sr = new StreamReader(refPath, Encoding.UTF8, false, 16384 * 2))

            {

                using (var rdr = new CsvReader(sr, cfg))

                using (var dataRdr = new CsvDataReader(rdr))

                {

                    result.Load(dataRdr);

                }

            }

            return result;

        }

    }

​

    public class Program

    {

        public static void Main()

        {

            Console.WriteLine("CsvHelper: " + typeof(CsvSerializer).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.CodeBase.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;

        }

    }

​