/// <summary>
/// Bulk copies a set of objects to the server.
/// </summary>
/// <param name="connection">The connection to use.</param>
/// <param name="tableName">The name of the table.</param>
/// <param name="reader">The reader to read objects from.</param>
/// <param name="configure">A callback method to configure the bulk copy object.</param>
/// <param name="options">Options for initializing the bulk copy object.</param>
/// <param name="transaction">An optional transaction to participate in.</param>
public override void BulkCopy(IDbConnection connection, string tableName, IDataReader reader, Action<InsightBulkCopy> configure, InsightBulkCopyOptions options, IDbTransaction transaction)
{
if (reader == null) throw new ArgumentNullException("reader");
if (transaction != null)
throw new ArgumentException("OracleProvider does not support external transactions for bulk copy", "transaction");
OracleBulkCopyOptions oracleOptions = OracleBulkCopyOptions.Default;
if (options.HasFlag(InsightBulkCopyOptions.UseInternalTransaction))
oracleOptions |= OracleBulkCopyOptions.UseInternalTransaction;
using (var bulk = new OracleBulkCopy((OracleConnection)connection, oracleOptions))
using (var insightBulk = new OracleInsightBulkCopy(bulk))
{
bulk.DestinationTableName = tableName;
// map the columns by name, in case we skipped a readonly column
foreach (DataRow row in reader.GetSchemaTable().Rows)
bulk.ColumnMappings.Add((string)row["ColumnName"], (string)row["ColumnName"]);
if (configure != null)
configure(insightBulk);
bulk.WriteToServer(reader);
}
}
/// <summary>
/// Bulk copies a set of objects to the server.
/// </summary>
/// <param name="connection">The connection to use.</param>
/// <param name="tableName">The name of the table.</param>
/// <param name="reader">The reader to read objects from.</param>
/// <param name="configure">A callback method to configure the bulk copy object.</param>
/// <param name="options">Options for initializing the bulk copy object.</param>
/// <param name="transaction">An optional transaction to participate in.</param>
public override void BulkCopy(IDbConnection connection, string tableName, IDataReader reader, Action <InsightBulkCopy> configure, InsightBulkCopyOptions options, IDbTransaction transaction)
{
if (reader == null)
{
throw new ArgumentNullException("reader");
}
if (transaction != null)
{
throw new ArgumentException("OracleProvider does not support external transactions for bulk copy", "transaction");
}
OracleBulkCopyOptions oracleOptions = OracleBulkCopyOptions.Default;
if (options.HasFlag(InsightBulkCopyOptions.UseInternalTransaction))
{
oracleOptions |= OracleBulkCopyOptions.UseInternalTransaction;
}
using (var bulk = new OracleBulkCopy((OracleConnection)connection, oracleOptions))
using (var insightBulk = new OracleInsightBulkCopy(bulk))
{
bulk.DestinationTableName = tableName;
// map the columns by name, in case we skipped a readonly column
foreach (DataRow row in reader.GetSchemaTable().Rows)
{
bulk.ColumnMappings.Add((string)row["ColumnName"], (string)row["ColumnName"]);
}
if (configure != null)
{
configure(insightBulk);
}
bulk.WriteToServer(reader);
}
}
/// <summary>
/// Bulk copies a set of objects to the server.
/// </summary>
/// <param name="connection">The connection to use.</param>
/// <param name="tableName">The name of the table.</param>
/// <param name="reader">The reader to read objects from.</param>
/// <param name="configure">A callback method to configure the bulk copy object.</param>
/// <param name="options">Options for initializing the bulk copy object.</param>
/// <param name="transaction">An optional transaction to participate in.</param>
public override void BulkCopy(IDbConnection connection, string tableName, IDataReader reader, Action<InsightBulkCopy> configure, InsightBulkCopyOptions options, IDbTransaction transaction)
{
if (transaction != null)
throw new ArgumentException("OracleProvider does not support external transactions for bulk copy", "transaction");
OracleBulkCopyOptions oracleOptions = OracleBulkCopyOptions.Default;
if (options.HasFlag(InsightBulkCopyOptions.UseInternalTransaction))
oracleOptions |= OracleBulkCopyOptions.UseInternalTransaction;
using (var bulk = new OracleBulkCopy((OracleConnection)connection, oracleOptions))
using (var oracleBulk = new OracleInsightBulkCopy(bulk))
{
bulk.DestinationTableName = tableName;
if (configure != null)
configure(oracleBulk);
bulk.WriteToServer(reader);
}
}
