using System;

using ChoETL;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

            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().WithMaxScanRows(1).OfType<ChoDynamicObject>();

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

​

            using (var w = new ChoCSVWriter(Console.Out).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);

                    }

                }

            }

    }

}