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