CSV

CSV accessing.

In Trivial.Text namespace of Trivial.dll library.

CSV parser

You can parse a CSV text by following way.

var csv = new CsvParser("ab,cd,efg\nhijk,l,mn");
foreach (var item in csv)
{
    Console.WriteLine("{0}    {1}    {2}", item[0], item[1], item[2]);
}
// Output:
// ab    cd    efg
// hijk    l    mn

If you have a model like following.

class Model
{
    public string FieldText { get; set; }
    public int FieldNumber { get; set; }
}

Now you can map to the CSV file.

var csv = new CsvParser("abcdefg,123\n\"hijk,lmn\", 456");
foreach (var model in csv.ConvertTo<Model>(new[] { "FieldText", "FieldNumber" }))
{
    Console.WriteLine("{0}    {1}", model.FieldText, model.FieldNumber);
}
// Output:
// abcdefg    123
// hijk,lmn    456

And you can also send this instance into StringTableDataReader construct with field names to load it as a DbDataReader object.