Example use of CsvHelper nuget package; also example usage of dynamic and RouteValueDictionary

CsvHelperExample.cs

public static void ImportPricingFile()
{
    using (var streamReader = new StreamReader(@"C:\Users\d.gallmeier\gits\daytoday\20180308\pricingFile.csv"))
    using (var csv = new CsvReader(streamReader))
    using (var db = new SqlConnection(Config.AthenaConnectionString))
    {
        var pricingLines = csv
            .GetRecords<dynamic>()
            .Select(record =>
            {
                var keyValueDictionary = new RouteValueDictionary(record);
                var pricingEntry = new ProductMargin
                {
                    itemId = Convert.ToInt64(Convert.ToInt64(keyValueDictionary["ItemID"]).ToString()),
                    manufacturer = keyValueDictionary["Manufacturer"].ToString(),
                    category = keyValueDictionary["Category"].ToString(),
                    d2cMargin = Convert.ToDecimal(keyValueDictionary["D2C margin %"].ToString()),
                };

                return pricingEntry;
            })
            .ToList();

        pricingLines.BulkCopyToDatabase("ProductMargins", db.ConnectionString, "dbo");
    }
}