You want to perform a Bulk Operations (BulkUpdate, BulkDelete, or BulkMerge) but using a different key than the one specifying.
By example, you want to perform a BulkUpdate on a customer list but by using the customer “Code” instead of the “CustomerID” for the key.
You can specify the column to use for the key with the ColumnPrimaryKeyExpression options.
You receive the following error:
An error occurred because the primary key specified is not unique, you can set the property ‘AllowDuplicateKeys’ to true to allow duplicate key
This error happens because the key is used in more than one row in the source
The code “001” is here more than once with a different name.
You can allow duplicate key with the AllowDuplicateKeys options