public void BulkCopyWriteToServer(DataTable data, string tableName) { using (var connection = _database.CreateConnectionForBulkCopy()) { try { connection.Open(); using (var bulkCopy = new OracleBulkCopy(connection)) { bulkCopy.DestinationTableName = tableName; bulkCopy.WriteToServer(data); } } catch (Exception ex) { throw ex; } finally { connection.Close(); } } }