I uses BulkMerge method of Entity Framework Extensions for insert/update large collections of entities. Entity table have identity column Id that used as a primary key. When I try to BulkMerge collection with several newly created entities (they have Id = 0 by default) it throws such exception: Violation of PRIMARY KEY constraint 'PK_Users'. Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is (0). Btw, BulkInsert method with same entities works fine. I tried to use options like AutoMapOutputDirection, InsertIfNotExists or MergeKeepIdentity but they were ineffective. Can anyone suggest the correct options for proper BulkMerge work or any other ways to solve issue?
Entity Framework Extensions: Can't BulkMerge entities with empty identity property
370 views Asked by Dmitriy Marov At
0
There are 0 answers
Related Questions in C#
- How to call a C language function from x86 assembly code?
- What does: "char *argv[]" mean?
- User input sanitization program, which takes a specific amount of arguments and passes the execution to a bash script
- How to crop a BMP image in half using C
- How can I get the difference in minutes between two dates and hours?
- Why will this code compile although it defines two variables with the same name?
- Compiling eBPF program in Docker fails due to missing '__u64' type
- Why can't I use the file pointer after the first read attempt fails?
- #include Header files in C with definition too
- OpenCV2 on CLion
- What is causing the store latency in this program?
- How to refer to the filepath of test data in test sourcecode?
- 9 Digit Addresses in Hexadecimal System in MacOS
- My server TCP doesn't receive messages from the client in C
- Printing the characters obtained from the array s using printf?
Related Questions in ENTITY-FRAMEWORK-6
- EF6 Find function always go to the DB
- Using EF (not EF Core) with .NET 6 or above
- EF generates query with not supported minus sign in MS SQL (f.e. norvegian culture)
- Why ConfigurationManager.ConnectionStrings returns only a default LocalDb ASP.Net Cnx?
- HasComputedColumnSql() method not working as Expected
- How to establish 1:1 relationship with 2 composite keys in EF6 (not core)
- Error adding an owned entity to the parent entity using ASP.NET Core 6 Web API
- Injecting UserStore and UserManager into Controller throws exception
- What is difference between ComplexType and OwnsOne in Entity Framework Core?
- Entity Framework 6 - modify nested collection by using DbCommandInterceptor
- Entity Framework 6 - update entity value during loading
- How to generate Concurrency exceptions in Entity Framework?
- How is the DeleteStatus in associated tables updated when DeleteStatus is true in a table?
- Update modified date when referenced entities are edited
- Disable only Inserts and Updates for one entity in EF 6
Related Questions in ENTITY-FRAMEWORK-EXTENSIONS
- Entity Framework Extension Mismatch Error with Oracle DB (EDMX model)
- Does BulkMerge update the provided entity objects?
- BulkInsert error using Entity Framework Extensions
- Fluent API: Define both "many to many" as relationship and as relationship object too
- Why EF Extensions not throwing an exception when there is any such entity on table to delete?
- EF Extensions BulkDelete method doesn't delete with foreign keys
- How to activate Entity Framework Extensions license in global.asax file?
- Z.EntityFramework.Extensions.EFCore BulkMerge - Non Key Indexing to Update Records on Mass
- Which flag we need to set to ensure community version of EF Plus?
- Dynamically update table using Dynamic LINQ
- Entity Framework Extensions Recursive Query
- Entity Framework Extensions: Can't BulkMerge entities with empty identity property
- C# Does UpdateFromQuery work with InMemory DB?
- C# Entity Framework: Bulk Extensions Input Memory Issue
- How to write an extension for the Entity Framework Core
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)