private static void CreateTable()
{
using (var conn = new SqlConnection(TestDbConnection.LocalDb.Northwind))
{
conn.Open();
string sqlCommand = Northwind_Tables.Customers_Create();
conn.Execute(sqlCommand);
}
}
private static void PrepareData()
{
List <Customer_Data> sourceData = new List <Customer_Data>();
using (var sr = new StreamReader(@"Customer_Data.csv"))
{
using (var reader = new CsvReader(sr))
{
var records = reader.GetRecords <Customer_Data>();
sourceData.AddRange(records);
}
}
using (var conn = new SqlConnection(TestDbConnection.LocalDb.Northwind))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
var sqlCommand = Northwind_Tables.Customers_Insert();
conn.Execute(sqlCommand, sourceData, transaction: trans);
trans.Commit();
}
}
}
