public void Setup()
{
var settings = new Settings();
this.src = new OleDbConnection(settings.GoldConnStr);
this.dest = new SqlConnection(settings.PyriteConnStr);
this.src.Open();
this.dest.Open();
var command = this.dest.CreateCommand();
var tables = new string[] { "AccountToResponsibility", "Account", "Department", "Office", "Title", "Responsibility" };
foreach (string table in tables) {
command.CommandText = "DELETE FROM " + table;
command.ExecuteNonQuery();
}
}
public void TestInitialize()
{
var settings = new Settings();
this.src = new OleDbConnection(settings.GoldConnStr);
this.src.Open();
this.dest = new SqlConnection(settings.PyriteConnStr);
this.dest.Open();
}