v4.0.0
Download the library here
- BREAKING CHANGE: The option
AllowDuplicateKeys
is no longer enabled by default. This option was here since the first version, it has been working well for SQL Server but was always caused some trouble in some other provider such asSQLite
. It was also slowing the bulk operations for all providers.
The AllowDuplicateKeys
was allowing you to pass the entities multiple times in the same list. While this is very nice to have, this was causing some trouble for BulkInsert
and BulkMerge
when the key is empty (not set!) in some providers.
You can re-enable it globally with the following code:
BulkOperationManager.BulkOperationBuilder = builder => builder.AllowDuplicateKeys = true;
For a chaining action:
connection.UseBulkOptions(options => options.AllowDuplicateKeys = true).BulkInsert(list);
For a specific entity:
DapperPlusManager.Entity<EntitySimple>().UseBulkOptions(options => options.AllowDuplicateKeys = true);
Trial unlocked until the end of April