BulkInsert Error after upgrading to Ef Core .Net 8 with latest Extensions about entityframework-extensions HOT 2 CLOSED

Hello @rabberbock ,

This issue happens when there is a duplicate (exactly the same instance) of one of your entities in the list such as:

var customerA = new Customer();
var customerB = new Customer();

var list = new List<Customer>();
list.Add(customerA);
list.Add(customerA); // added twice
list.Add(customerB);

We had some inconsistency before about how this scenario was handled (for example, BulkInsert was working, but Include Graph was throwing an error, so indeed starting from v7.100.0.0, this error start to appear for more scenarios.

Is there a reason on your side that an entity would be a duplicate in your list?

Obviously, to fix it, you can simply use the Distinct method, but that's maybe not something you can do:

context.BulkInsert(list.Distinct());

Best Regards,

Jon

from entityframework-extensions.

@JonathanMagnan Thanks for the detailed explanation! That was exactly it and we don't need duplicates in our scenario. So all good to go on this issue.

from entityframework-extensions.