Db2BulkInsertMapItem

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

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

Used by the Db2 BulkInsert, BulkMerge and BulkUpdate operations.

Create a new Instance

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

Or with an explicit DB2Type:

var mapItem = new Db2BulkInsertMapItem("SourceName", "DestinationName", DB2Type.VarChar);

Usage for BulkOperations

var mappings = new []
{
    new Db2BulkInsertMapItem("FirstName", "FName"),
    new Db2BulkInsertMapItem("LastName", "LName"),
    new Db2BulkInsertMapItem("Age", "Age", DB2Type.Integer)
};

using (var connection = new DB2Connection(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).