Link Search Menu Expand Document

OracleBulkImportIdentityBehavior


This enum defines the behavior of the identity property/column when an entity is bulk-imported into a target table. It applies only to Oracle.

Enum Values

NameDescription
UnspecifiedNo action is required. (This is the default value)
KeepIdentityThe value of the identity property/column will be kept and used.
ReturnIdentityThe newly generated identity value from the target table will be set back to the entity.

Usability

This enum is used by both the BulkInsert and BulkMerge operations. Pass the value to the identityBehavior argument when calling the operation.

For BulkInsert:

using (var connection = new OracleConnection(connectionString))
{
    var people = GetPeople(1000);
    var insertedRows = connection.BulkInsert(people,
        identityBehavior: OracleBulkImportIdentityBehavior.ReturnIdentity);
}

For BulkMerge:

using (var connection = new OracleConnection(connectionString))
{
    var people = GetPeople(1000);
    var mergedRows = connection.BulkMerge(people,
        identityBehavior: OracleBulkImportIdentityBehavior.ReturnIdentity);
}