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.