Link Search Menu Expand Document

BulkImportIdentityBehavior


This enum is used to define the behavior of the identity property/column when an entity is being bulk-imported towards the target table. It is only used for PostgreSQL RDBMS.

Enum Values

Below is the list of enum values.

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

Usability

This enum is being used by both the BinaryBulkInsert and BinaryBulkMerge operations. Simply pass the value to the identityBehavior argument when calling the operation.

For BinaryBulkInsert operation, see below.

using (var connection = new NpgsqlConnection(connectionString))
{
    var people = GetPeople(1000);
    var insertedRows = connection.BinaryBulkInsert(people,
        identityBehavior: BinaryImportIdentityBehavior.ReturnIdentity);
}

For BinaryBulkMerge operation, see below.

using (var connection = new NpgsqlConnection(connectionString))
{
    var people = GetPeople(1000);
    var mergedRows = connection.BinaryBulkMerge(people,
        identityBehavior: BinaryImportIdentityBehavior.ReturnIdentity);
}