OracleBulkInsertMapItem

A mapping class used to define a column mapping, with an optional explicit OracleDbType, for the Oracle bulk operations.

This class extends BulkInsertMapItem with an optional, explicit OracleDbType to bind with for the mapped column. When not provided, the type is inferred from the entity property’s OracleDbType/OracleDbTypeEx attribute (if present) or, failing that, from the .NET CLR value itself.

Used by the Oracle BulkInsert, BulkMerge and BulkUpdate operations.

Create a new Instance

var mapItem = new OracleBulkInsertMapItem("SourceId", "DestinationId");

Or with an explicit OracleDbType:

var mapItem = new OracleBulkInsertMapItem("SourceName", "DestinationName", OracleDbType.NVarchar2);

Usage for BulkOperations

var mappings = new []
{
    new OracleBulkInsertMapItem("FirstName", "FName"),
    new OracleBulkInsertMapItem("LastName", "LName"),
    new OracleBulkInsertMapItem("Age", "Age", OracleDbType.Int32)
};

using (var connection = new OracleConnection(connectionString))
{
    var people = GetPeople(100000);
    connection.BulkInsert(people, mappings: mappings);
}

The same approach applies to BulkMerge and BulkUpdate. The mappings argument is optional — omitting it causes the library to auto-map columns by name (case-insensitive).