using System;

using System.Collections.Generic;

using System.Reflection;            

using System.Text;

using System.Linq;

using ServiceStack;

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        string value1 = "This is a test";

        Console.WriteLine("value1=" + value1);

        Console.WriteLine("formatted1=" + FormatValueForCSV(value1));

        Console.WriteLine("----------");

        string value2 = "This is a " + (char)34 + "test" + (char)34 + " 2";

        Console.WriteLine("value2=" + value2);

        Console.WriteLine("formatted2=" + FormatValueForCSV(value2));

        Console.WriteLine("----------");

        string value3 = "This " + (char)34 + "is" + (char)34 + " a " + (char)34 + "test" + (char)34 + " 2";

        Console.WriteLine("value3=" + value3);

        Console.WriteLine("formatted3=" + FormatValueForCSV(value3));

        Console.WriteLine("----------");

        List<TestItem> items = new List<TestItem>();

        var item = new TestItem();

        item.Name = "Jason Snelders";

        item.Age = 40;

        item.DoB = new DateTime(1981, 1, 14);

        item.Message = "Hello world. Jason's world. \\Onky!";

        items.Add(item);

        item = new TestItem();

        item.Name = "Damelza Snelders";

        item.Age = 40;

        item.DoB = new DateTime(1981, 7, 15);

        item.Message = value3;

        items.Add(item);    

        //string csv = ToCsv<TestItem>(",", items);

        // Via: https://stackoverflow.com/questions/25683161/fastest-way-to-convert-a-list-of-objects-to-csv-with-each-object-values-in-a-new/25683993

        // Source: https://github.com/ServiceStack/ServiceStack.Text

        string csv = ServiceStack.Text.CsvSerializer.SerializeToString<List<TestItem>>(items);

        Console.WriteLine("ToCsv=");

        Console.WriteLine(csv);

        Console.WriteLine("----------");

    }

​

​

    public class TestItem

    {

        public string Name { get; set; } = "";

        public int Age { get; set; } 

        public DateTime DoB { get; set; } 

        public string Message { get; set; } = "";

    }

    private static object ObjectToCSV(object item)

    {

        string line = "";

        return line;

    }

    private static string FormatValueForCSV(string value)

    {

        string formatted = "";

        formatted = value;

        // Replace double quotes ["] with backslace escaped double quest [\"]

        formatted = formatted.Replace("\"", "\\\"");

        return formatted;

    }

    // Source (adpted): https://gist.github.com/SuperYeti/959854

    public static string ToCsv<T>(string separator, IEnumerable<T> objectlist) 

    { 

        Type t = typeof(T); 

        PropertyInfo[] fields = t.GetProperties(); 

​

        string header = String.Join(separator, fields.Select(f => f.Name).ToArray()); 

​

        StringBuilder csvdata = new StringBuilder(); 

        csvdata.AppendLine(header); 

​

        foreach (var o in objectlist) 

        csvdata.AppendLine(ToCsvFields(separator, fields, o)); 

​

        return csvdata.ToString(); 

    } 

​

    public static string ToCsvFields(string separator, PropertyInfo[] fields, object o) 

    { 

        StringBuilder linie = new StringBuilder(); 

​

        foreach (var f in fields) 

        { 

            if (linie.Length > 0) 

            linie.Append(separator); 

​

            var x = f.GetValue(o); 

​

            if (x != null) 

            //linie.Append(x.ToString()); 

            linie.Append("\"" + FormatValueForCSV(x.ToString()) + "\""); 

        } 

​

        return linie.ToString(); 

    }   

}

​

​

​