How is a bulk insert to Oracle from .net with C # language? [closed]

0

How to make a bulk-insert from .net for an Oracle database.

    
asked by Alejandro Soler 08.02.2016 в 17:39
source

1 answer

1

You can review OracleBulkCopy

You can download it with nuget with the following command

Install-Package Oracle.DataAccess.x86

And in code would be something like

using (OracleBulkCopy bulkCopy = new OracleBulkCopy(conexion))
{
  bulkCopy.DestinationTableName = TABLA;
  bulkCopy.BatchSize = 100000;
  bulkCopy.BulkCopyTimeout = 20000;
  bulkCopy.WriteToServer(data);// checar https://docs.oracle.com/cd/E11882_01/win.112/e23174/OracleBulkCopyClass.htm#CHDHHABB para ver que formato es el mas adecuado para usted      
  bulkCopy.Close();
  bulkCopy.Dispose();
  conexion.Dispose();
}
    
answered by 08.02.2016 / 17:56
source