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); } }