Bulk Merge does not exists and BulkInsert Options dont have "InsertIfNotExists"

[lucas-fsousa]

Description

Hello. I'm having trouble using the EF extension library for BULK INSERT and BULK MERGE.

My objective is to insert a massive amount of information from a table that in turn has thousands of records, but these records cannot be duplicated in any way. I have a Unique Index that does the job of avoiding duplication.

When using BulkInsert according to the documentation at https://entityframework-extensions.net/bulk-insert

If I send my data using

context.BulkInsert(data)

and there are any duplicate records, an exception will occur as I expect it to happen.

The documentation contains an example

context.BulkInsert(customers, options => { 
    options.InsertIfNotExists = true;
    options.PrimaryKeyExpression = customer => customer.Code;
  });

I replicated the same to do some tests and

options.InsertIfNotExists = true;
options.PrimaryKeyExpression = customer => customer.Code

Does not exist in BulkConfig

See here a capture I made of the example copied directly from the documentation. I looked for any nuget packages that might be missing, but I didn't find anything. Any idea what it is?

As I had no success with BulkInsert, I looked for BulkMerge which would possibly solve my problem using this topic https://entityframework-extensions.net/bulk-merge#bulk-merge-with-options. But to my surprise, BulkMerge doesn't exist in the package. See the image below.

Further technical details

• EFCore.BulkExtensions [v8.1.1]
• EFCore.BulkExtensions.SqlServer [v8.1.1]
• Microsoft.EntityframeworkCore [v8.0.10]
• Microsoft.EntityframeworkCore.SqlServer [v8.0.10]

[JonathanMagnan]

Hello @lucas-fsousa ,

You are currently using the wrong package.

Unfortunately, this other paid package chose a name that is very similar to ours, which confuses a lot of people.

You can find our package here: https://www.nuget.org/packages/Z.EntityFramework.Extensions.EFCore/

Make sure to use the latest v8.x of our package (currently v8.103.5) (the first number but correspond to your EF Core version).

Let me know if that solves your issue.

Best Regards,

Jon

[lucas-fsousa]

It seems to be working well! I will do some tests to see if the problem will be resolved.

But for this case. It's all right. Thanks!