Comments (5)
Hello @calemith ,
DestinationTable
is the alias used by our script for the table/view EntryRaw
.
Is EntryRaw
a view? If yes, could you try a simple insert directly in SSMS (without our library) to see if you get the same error?
I currently believe that you currently try to perform an operation on a read-only
view.
See: https://stackoverflow.com/a/25472496/5619143
Best Regards,
Jonathan
from dapper-plus.
Hello Jonathan,
EntryRaw is a table. I tried a direct single insert through SSMS and it works fine. Is there an intermediary view that is used when performing the bulk insert?
from dapper-plus.
Nope,
Beside temporary table, we don't create anything.
That's a weird one,
Could you try with one row and if that fail, to use SQL Profiler to get the SQL executed and execute it directly in SSMS?
Perhaps that will point us in the right direction.
Best Regards,
Jonathan
from dapper-plus.
hey John,
Found the issue. Even though we transformed the list of objects to a new type, they were still the type that was named the same as a Read only- view we were using.
We fixed it by doing a proper mapping to the correct type. thanks for your help!
from dapper-plus.
Oh, that's great ;)
Best Regards,
Jonathan
from dapper-plus.
Related Issues (20)
- A transport-level error for NVarchar(max) column when using auditing HOT 7
- Received an invalid column length from the bcp client for colid HOT 3
- Set ColumnSynchronizeDeleteKeySubsetExpression without .Entity<Whatever>()? HOT 4
- IndexOutOfRangeException on BulkMerge operations HOT 1
- ILogger not logging, but Console.WriteLine works? HOT 3
- Configure Merge for concurrency handling HOT 3
- Ids not coming back after first BulkInsert HOT 4
- Update trigger on target table causes BulkMerge to fail HOT 3
- Feature Request - suppress update if nothing changed. HOT 2
- BulkInsert doesn't generate primary key for multiple concurrent submission HOT 7
- Support for Sybase for Bulk Insert HOT 1
- Skip duplicate records on bulk insert HOT 5
- Avoid output HOT 7
- BulkInsert Postgres => An error occured while retrieving the InformationSchemaTable information. See the inner exception for details. HOT 4
- Dapper Plus can't map Id when use galera cluster HOT 3
- bulk insert very slow on mariadb version≥10.6.0 HOT 2
- PostgreSQL BulkMerge / BulkUpdate always returns all rows as update HOT 6
- Bulk Insert throws the exception 'Unknown data type' whenever inserting GUID to MySQL HOT 4
- Does this support DateOnly/TimeOnly? HOT 6
- Does this support Aot 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 dapper-plus.