public void Setup()
{
string connectionString = this.GetConnectionString();
AdventureWorksSchema schema = new AdventureWorksSchema();
this.ClassUnderTest = this.CreateClassUnderTest(schema, connectionString);
this.ClassUnderTest.ClearDatabase();
}
private void LoadAddressDataRows(AdventureWorksSchema schema)
{
foreach (var addressLine in this.GetTextFileLines("Address.txt"))
{
string[] allAddressColumns = addressLine.Split('|');
var addressId = int.Parse(allAddressColumns[0]);
schema.Address.Rows.Add(addressId, allAddressColumns[1], allAddressColumns[2], allAddressColumns[3], allAddressColumns[4], allAddressColumns[5], allAddressColumns[6], DateTime.Parse(allAddressColumns[7].ToString()).ToString("yyyy-MM-dd H:mm:ss"));
}
}
/// <summary>
/// Load the address table
/// </summary>
private void LoadAddressTable(DbConnection cnn, Action <AdventureWorksSchema> loadAddressRows, string selectCommandText)
{
AdventureWorksSchema awDataset = new AdventureWorksSchema();
var factory = DbProviderFactories.GetFactory(cnn);
DbDataAdapter adapter = factory.CreateDataAdapter();
adapter.SelectCommand = factory.CreateCommand();
adapter.SelectCommand.CommandText = selectCommandText;
adapter.SelectCommand.Connection = cnn;
DbCommandBuilder commandBuilder = factory.CreateCommandBuilder();
commandBuilder.DataAdapter = adapter;
commandBuilder.GetInsertCommand();
loadAddressRows(awDataset);
adapter.Update(awDataset, "Address");
}
private void LoadCustomerDataRows(AdventureWorksSchema schema)
{
foreach (var customerLine in this.GetTextFileLines("Customer.txt"))
{
string[] allCustomerColumns = customerLine.Split('|');
var customerId = int.Parse(allCustomerColumns[0]);
schema.Customer.Rows.Add(
customerId,
false,
allCustomerColumns[2],
allCustomerColumns[3],
allCustomerColumns[4],
allCustomerColumns[5],
allCustomerColumns[6],
allCustomerColumns[7],
allCustomerColumns[8],
allCustomerColumns[9],
allCustomerColumns[10],
allCustomerColumns[11],
allCustomerColumns[12],
//allCustomerColumns[13],
DateTime.Parse(allCustomerColumns[14].ToString()).ToString("yyyy-MM-dd H:mm:ss"));
}
}
