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)
- 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
- BulkUpdate and BulkMerge Do Not Apply Any Changes To The Table with Owned Entity HOT 1
- BulkSaveChanges results in Foreign Key Constraint Violation but SaveChanges works HOT 3
- BulkMerge is Causing Violation of PRIMARY KEY constraint HOT 1
- BulkInsert: System.IndexOutOfRangeException: 'There is no row at position 0.' HOT 4
- While inserting new record through BulkMerge it's not overriding default constraint value HOT 3
- The type initializer for 'Z.BulkOperations.LicenseManager' threw an exception HOT 13
- `PublicExtensions` static dictionaries are filling up HOT 4
- SQLite Invalid cast from 'System.String' to 'System.Guid' HOT 4
- IDbCommandInterceptor does not fire when using BulkInsert or BulkDelete HOT 2
- WhereBulkContains does not work when table inherit from another table HOT 1
- Feat: Conditional insert HOT 3
- EFcore 8 UpdateFromQuery generates invalid sql HOT 4
- Microsoft.Data.SqlClient is on a vulnerable version - security update HOT 1
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.