Comments (4)
Thank you mafshin for reporting,
Which database provider are you using? We did some test and everything seem to work under SQL Server/Azure?
from entityframework-extensions.
I'm using EF 6.1.3 with SQLServer
from entityframework-extensions.
Thank you,
I know exactly where this issue appears, but I still don't understand why this is not working in your environment or how this is happening.
My guess is something modify the SQL and make it all in lower case or upper case (which modify the case of the "ZZZ_Index" column name!).
Do you have any idea if in your environment something could change the SQL? Can you provide using SQL Profiler the SQL which is executed?
Example
exec sp_executesql N'MERGE INTO [dbo].[EntitySimples] AS DestinationTable
USING
(
SELECT * FROM #ZZZProjects_e7af87cb_81de_4564_bfd1_e0e1b2a0ec9d
WHERE ZZZ_Index >= @IndexStart AND ZZZ_Index <= @IndexEnd
) AS StagingTable
ON 1 = 2
WHEN NOT MATCHED THEN
INSERT ( [IntColumn] )
VALUES ( [IntColumn] )
OUTPUT
$action,
StagingTable.ZZZ_Index,
INSERTED.[ID] AS [ID_zzzinserted]
;',N'@IndexStart int,@IndexEnd int',@IndexStart=0,@IndexEnd=100
from entityframework-extensions.
Closing Issue: No answer
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 3
- 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.