using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.IO;

using System.Globalization;

​

using CsvHelper;

using CsvHelper.Configuration;

using CsvHelper.Configuration.Attributes;

using CsvHelper.Expressions;

using CsvHelper.TypeConversion;

​

using Microsoft.VisualStudio.TestTools.UnitTesting;

​

#nullable enable

​

//https://stackoverflow.com/questions/79588082/csvreader-csvhelper-classmap-throug-interface-to-getrecords-return-nothing

// MCVE here: https://dotnetfiddle.net/arWrin

​

public interface ITestSaccaModel

{

    public bool IsSelected { get; set; }

    public bool IsModified { get; set; }

    public bool IsDeleted { get; set; }

    public Guid UIDOriginal { get; set; }

    public string SomeValue { get; set; }

}

​

public class TestSaccaModelBaseClass : ITestSaccaModel

{

    public bool IsSelected { get; set; }

    public bool IsModified { get; set; }

    public bool IsDeleted { get; set; }

    public Guid UIDOriginal { get; set; }

    public string SomeValue { get; set; } = "My Value";

}

​

public class TestSaccaModel : TestSaccaModelBaseClass;

​

public sealed class TestSaccaModelMap<TTestSaccaModel> : ClassMap<TTestSaccaModel> 

    where TTestSaccaModel : ITestSaccaModel

{

    public TestSaccaModelMap()

    {

        AutoMap(CultureInfo.InvariantCulture);

        Map(m => m.IsSelected).Ignore();

        Map(m => m.IsModified).Ignore();

        Map(m => m.IsDeleted).Ignore();

        Map(m => m.UIDOriginal).Ignore();

    }

}

​

class TestClass

{

    static readonly string CsvDelimiter = ",";

    static readonly string fileName = "Question79588082.csv";

    public static (bool exists, string csvFileName) ExportDataCSV(List<ITestSaccaModel> data, string csvFileName)

    {

        var config = new CsvConfiguration(CultureInfo.InvariantCulture)

        {

            Delimiter = CsvDelimiter,

            HasHeaderRecord = true,

        };

​

        using (var writer = File.CreateText(csvFileName))

        using (var csv = new CsvWriter(writer, config))

        {

            csv.Context.RegisterClassMap<TestSaccaModelMap<ITestSaccaModel>>();

            csv.WriteRecords(data);

        }

​

        return (File.Exists(csvFileName), csvFileName);

    }

​

    [TestMethod]

    public void Export_Data_To_CSV()

    {

        List<ITestSaccaModel> _dataCollection = new ()

        {

            new TestSaccaModel { SomeValue = "Value 1" },

            new TestSaccaModel { SomeValue = "Value 2" }

        };

​

        // Act

​

        var result = ExportDataCSV(_dataCollection.ToList(), fileName);

​

        Console.WriteLine(File.ReadAllText(result.csvFileName));

        IEnumerable<ITestSaccaModel> csvRecords;

​

        var config = new CsvConfiguration(CultureInfo.InvariantCulture)

        {

            // Make sure these settings match the serialization settings

            Delimiter = ";",

            HasHeaderRecord = true,

            //HeaderValidated = null, -- no longer necessary

            //ReadingExceptionOccurred = _ => false  -- no longer necessary

        };

​

        using (var stream = File.OpenText(fileName))

        using (var csv = new CsvReader(stream, config))

        {

            csv.Context.RegisterClassMap<TestSaccaModelMap<TestSaccaModel>>();

            csvRecords = csv.GetRecords<TestSaccaModel>().ToList();

        }

​

        csvRecords.Dump();

        NUnit.Framework.Assert.That(csvRecords.Count() == _dataCollection.Count);

        NUnit.Framework.Assert.That(System.Text.Json.JsonSerializer.Serialize(csvRecords) == System.Text.Json.JsonSerializer.Serialize(_dataCollection));

    }

​

    public static void Test()

    {

        new TestClass().Export_Data_To_CSV();

    }   

}

​

    public class Program

    {

        public static void Main()

        {

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

            Console.WriteLine("OS Version: {0}, NewLine: {1}", System.Environment.OSVersion, System.Text.Json.JsonSerializer.Serialize(Environment.NewLine));

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

            Console.WriteLine();

​

            try

            {

                TestClass.Test();

            }

            catch (Exception ex)

            {

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

                Console.WriteLine(ex);

                throw;

            }

        }

    }

​