public void CreateDataTableInDatabaseTest()
{
const string TableName = "TempTable";
// create the datatable and add some columns
var dataTable = new DataTable();
dataTable.TableName = TableName;
dataTable.Columns.Add(
new DataColumn()
{
DataType = Type.GetType("System.Int32"), ColumnName = "RowID", AutoIncrement = true
});
dataTable.Columns.Add(
new DataColumn()
{
DataType = Type.GetType("System.String"), ColumnName = "Col1"
});
dataTable.Columns.Add(
new DataColumn()
{
DataType = Type.GetType("System.Int32"), ColumnName = "Col2"
});
SqlTableBuilder.CreateTableSchemaFromDataTable(testDatabase.ConnectionString, dataTable);
Assert.IsTrue(this.TableExists(TableName, testDatabase.ConnectionString));
}
internal SqlBulkInsertAdapter(string schemaFileName, string connectionString, int batchSize = 1000)
{
this.connectionString = connectionString;
this.batchSize = batchSize;
this.dataTable = this.GenerateDataTableFromXmlFile(schemaFileName);
// use the db connections to create table schema in the database
SqlTableBuilder.CreateTableSchemaFromDataTable(connectionString, this.dataTable);
}