Dr. Tim dos Santos comments

Results 7 comments of


                                            Dr. Tim dos Santos

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

Hi, I can confirm that the IDs returned by the BulkInsert call when PreserveInsertOrder and SetOutputIdentity is true are arbitrarily sorted and NOT correct. Entity instances get different ID values...

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

> Can you make a Test for this issue. I have added this one and it passed: > For me, the issue doesn't occur for small sized bulk inserts (a...

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

No, I meant I use negative "pre-IDs" for new entries, and I use them also to differentiate during debugging (so if I encounter entities with negative IDs while stepping through...

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

Yes, I'm using SqlServer; I'll try to create a minimal reproduction-example project, but I didn't succeed just yet (a new minimal project with 8.1.2 showed the same correct behaviour as...

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

Unfortunately, I didn't succeed in reproducing the issue in a fresh project. This is bad, as the behaviour in 8.1.2 causes data corruption (wrong FKs) - I don't find the...

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

Same nuget 8.1.2 for my test-app

Calling BulkInsertOrUpdate with SetOutputIdentity=true, PreserveInsertOrder=true, returns data that contains data from other rows.

Will do, already checked out EF.BulkExtensions from github. I'll need a bit of time (not sure if I'll manage this in the rest of 2024 or in January). I'll come...