public void TestCsvExtractor() { var dt = CsvExtractor.GetDataTableFromCsv("./files/sampledata.csv", true); Assert.IsNotNull(dt); LogTableContents(dt); Assert.IsTrue(dt.Rows.Count == 4, string.Format("Expected 4 got {0}", dt.Rows.Count)); foreach (var c in dt.Columns) { Resolve <ILogger>().Info("co: {0}", (c as DataColumn).ColumnName); } Assert.IsTrue(dt.Columns[0].ColumnName == "Make", string.Format("Expected Make got {0}", dt.Columns[0].ColumnName)); }
public void TestSqlLoader() { var dt = CsvExtractor.GetDataTableFromCsv("./files/sampledata.csv", true); new SqlLoader(1).OnLoad(dt); }