using System;

using ChoETL;

using System.Text;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        typeof(ChoCSVReader).GetAssemblyVersion().Print();

        "".Print();

        string csv1 = @"ID,name

1,Danny

2,Fred

3,Sam";

​

        string csv2 = @"ID,name

1,Danny

3,Pamela

4,Fernando";

​

        //ChoTypeComparerCache.Instance.ScanAndLoad();

​

        var r1 = ChoCSVReader.LoadText(csv1).WithFirstLineHeader().WithDelimiter(",").WithMaxScanRows(1).OfType<ChoDynamicObject>();

        var r2 = ChoCSVReader.LoadText(csv2).WithFirstLineHeader().WithDelimiter(",").WithMaxScanRows(1).OfType<ChoDynamicObject>();

​

        string expectedOutput = @"ID,name,Status

1,Danny,Unchanged

2,Fred,Deleted

3,Pamela,Changed

4,Fernando,New";

​

        StringBuilder output = new StringBuilder();

        using (var w = new ChoCSVWriter(output).WithFirstLineHeader())

        {

            foreach (var t in r1.Compare(r2, "ID", "name"))

            {

                dynamic v1 = t.MasterRecord as dynamic;

                dynamic v2 = t.DetailRecord as dynamic;

                if (t.Status == CompareStatus.Unchanged || t.Status == CompareStatus.Deleted)

                {

                    v1.Status = t.Status.ToString();

                    w.Write(v1);

                }

                else

                {

                    v2.Status = t.Status.ToString();

                    w.Write(v2);

                }

            }

        }

​

        output.Print();

    }

}