private long DoBulkInsert(string tableName, DataTable dataTable) { IBulkOperations bulkOps = BulkOperationsFactory.Create(_connection); bulkOps.Connection = _connection; bulkOps.TableName = tableName; ValidateDatabaseTableStructure(tableName, dataTable); var countStart = CountRowsInTable(tableName); bulkOps.WriteToServer(dataTable); var countEnd = CountRowsInTable(tableName); return(countEnd - countStart); }