private void ResetTestTables()
{
using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString))
{
conn.ExecSql(File.ReadAllText(@"SQL\reset_jobs_and_person.sql"));
}
}
public void SpecialSchemaTest()
{
using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString))
{
const string tableName = "BulkLoadTestTableSpecial";
conn.ExecSql(string.Format("DELETE FROM {0}", tableName));
var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString);
var result = datSer.ImportTable(string.Format(@"resources\dbo.{0}.xml", tableName));
DataSerTestHelper.AssertResult(result);
var tableData = conn.ExecQuery(string.Format("SELECT * FROM {0}", tableName));
Assert.AreEqual(3, tableData.Rows.Count);
}
}
public void LoadStandaloneTableTest()
{
using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString))
{
var sql = File.ReadAllText(@"SQL\reset_tools_table.sql");
conn.ExecSql(sql);
}
using (var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString))
{
var result = datSer.ImportTableWithoutBulkCopy(@"Resources\Tools.xml");
DataSerTestHelper.AssertResult(result);
}
}
public void DifferentSchemaTest()
{
using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString))
{
conn.ExecSql(File.ReadAllText(@"SQL\reset_BulkLoadTestTable1.sql"));
var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString);
var result = datSer.ImportTable(@"resources\dbo.BulkLoadTestTable1.xml");
DataSerTestHelper.AssertResult(result);
var tableData = conn.ExecQuery("SELECT * FROM BulkLoadTestTable1");
Assert.AreEqual(3, tableData.Rows.Count);
var firstRowData = tableData.Rows[0].ItemArray;
CollectionAssert.AreEqual(new object[] {1, "Alpha", 11, DBNull.Value}, firstRowData);
}
}
