public void CommitDatatable(DataTable dataTable, bool dropCreate = true)
{
if (dropCreate)
{
string dropTableStatement = $@"IF OBJECT_ID('{schema}.{dataTable.TableName}') IS NOT NULL
DROP TABLE {schema}.{dataTable.TableName};";
ExecuteNonQuery(dropTableStatement);
ExecuteNonQuery(_queryFactory.CreateTable($"{schema}.{ dataTable.TableName}", dataTable));
}
BulkInsert($"{schema}.{ dataTable.TableName}", dataTable);
}