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

  • KeepIdentity - a value that indicates whether the value of the identity property/column will be kept and used.
  • ReturnIdentity - a value that indicates whether the newly generated identity value from the target table will be set back to the entity.
  • Unspecified - no 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);
}