public void TestBatchSizeReset()
{
TableUploader tu = new TableUploader();
int batchSizeBefore = tu.GetBatchSize();
const String tableName = "IN_WMAIL";
tu.Process(VfpConnectionString, tableName, SqlConnectionString, tableName);
int batchSizeAfter = tu.GetBatchSize();
Assert.IsTrue(batchSizeAfter > 0);
Assert.IsTrue(batchSizeAfter != batchSizeBefore);
}
public void TestEssexInWMailUpload()
{
VfpConnectionStringBuilder vfpConnStrBldr = new VfpConnectionStringBuilder(VfpConnectionString);
vfpConnStrBldr.DataSource = @"D:\Essex\Hostdema\";
String vfpConnStr = vfpConnStrBldr.ConnectionString;
String sqlConnStr = "Data Source = (local); Initial Catalog = Essex_22_000211; Integrated Security = True";
const String tableName = "IN_WMAIL";
Helper.ExecuteSqlNonQuery(sqlConnStr, "DELETE FROM " + tableName);
string expectedRecordCountCmdStr = "SELECT COUNT(*) FROM " + tableName;
int expectedRecordCount = Convert.ToInt32(Helper.GetOleDbScaler(vfpConnStr, expectedRecordCountCmdStr));
TableUploader tu = new TableUploader();
tu.Process(vfpConnStr, tableName, sqlConnStr, tableName);
int actualRecordCount = Convert.ToInt32(Helper.GetSqlScaler(sqlConnStr, expectedRecordCountCmdStr));
Assert.AreEqual(expectedRecordCount, actualRecordCount);
}