Comments (2)
Hello @meeper34 ,
You are right, we need the
MERGE
statement to return value (the only statement that allow us to return the correspondingZZZ_Index
without inserting the valueWhat kind of performance issue are you seeing? I mean the predicate
ON 1 = 2
should be pretty quick for SQL Server to resolve. So I'm not sure if using directly anINSERT
statement will make any difference in this case (I surely could be wrong).Best Regards,
Jon
Yea after researching some, I don't think a straight INSERT would really improve performance. Sorry to have wasted your time!
from entityframework-extensions.
Hello @meeper34 ,
You are right, we need the MERGE
statement to return value (the only statement that allow us to return the corresponding ZZZ_Index
without inserting the value
What kind of performance issue are you seeing? I mean the predicate ON 1 = 2
should be pretty quick for SQL Server to resolve. So I'm not sure if using directly an INSERT
statement will make any difference in this case (I surely could be wrong).
Best Regards,
Jon
from entityframework-extensions.
Related Issues (20)
- [8.0.0-rc.1] BulkMerge, BulkAdd do not update generated Identity values correctly? HOT 4
- Still missing column after updating database with Migration HOT 2
- Missing values in target table HOT 2
- Bulk synchronize problem with not null columns HOT 4
- MySql XAER_RMFAIL error with BulkSaveChanges and TransactionScope HOT 3
- 7.22.4 has undocumented breaking change in temporal table queries HOT 9
- InsertFromQuery ERROR: You currently try to map an entity type directly. You need to specify the property of this entity. HOT 2
- A failed bulk insert or update does not (always) tell which entities failed HOT 1
- ExecuteFutureAction (with useTransactions = true) swallows exceptions and can throw "The underlying provider failed on Rollback." exception HOT 2
- Npgsql.PostgresException: 23505: duplicate key value violates unique constraint HOT 6
- EF CORE 8 and Pgsql 8: Parameter without name in synchronize & merge HOT 3
- BulkInsert Error after upgrading to Ef Core .Net 8 with latest Extensions HOT 2
- BulkInsert Exception using NpgSql and jsonb in .NET 8 HOT 11
- Trial for EF core 7 HOT 3
- BulkInsert taking 20+ min for 80 000 data rows HOT 3
- Force output does not work for merge. HOT 3
- Invalid Cast. The update expression must be of type MemberInitExpression. HOT 3
- Bulk Operations for Postgres does not respect the PermanentTable setting HOT 2
- Avoid Prepared Statements for Bulk operations HOT 6
- WhereBulkContains throwing System.ArgumentNullException: 'Value cannot be null. (Parameter 'name')' HOT 15
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from entityframework-extensions.