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