public bool WriteToServer(string qualifiedDBName, DataTable dataTable) { OracleConnection objOracleCon = null; try { string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["OracleConnection"].ToString(); objOracleCon = new OracleConnection(connectionString); if (objOracleCon != null) { if (objOracleCon.State == ConnectionState.Closed) { objOracleCon.Open(); } using (OracleBulkCopy bulkCopy = new OracleBulkCopy(objOracleCon)) { bulkCopy.BatchSize = 100000; bulkCopy.BulkCopyTimeout = 20000; bulkCopy.DestinationTableName = qualifiedDBName; bulkCopy.WriteToServer(dataTable); bulkCopy.Close(); bulkCopy.Dispose(); objOracleCon.Dispose(); } } } catch (Exception exc) { return false; } finally { if (objOracleCon.State == ConnectionState.Open) { objOracleCon.Close(); } } return true; }
Close
objOracleCon
finally
using
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)