Comments (3)
Hello @Alexn ,
I should have said it in my first answer: you also need to select which properties you want to output.
Here is a working fork from your latest Fiddle: https://dotnetfiddle.net/XvCPIs
context.Set<Customer>().BulkInsert(customers, options =>
{
//options.ForceSelectOutput = true;
options.InsertIfNotExists = true;
options.InsertKeepIdentity = true;
options.ColumnOutputExpression = x => new { x.Name, x.Email, x.Note, x.Created, x.Updated };
options.ForceOutputFromUnmodifiedRow = true;
});
I commented the option options.ForceSelectOutput = true;
as it might not do what you think (This option, instead of directly outputting values, it output in a temporary table then select it, which is required in some scenario such as when we cannot automatically discover the table have a trigger)
from entityframework-extensions.
Hello @Alexn ,
Thank for reporting.
Unfortunately, we don't have any solution at this moment to cover this scenario.
We have the option options.ForceOutputFromUnmodifiedRow = true;
, but it currently only works in this 2 scenarios:
- BulkInsert + InsertIfNotExists
- BulkMerge without an
UPDATE
statement
We currently have a new method under development that will allow you to read and output values directly into your entities, but it will still take several weeks before we complete it.
Best Regards,
Jon
from entityframework-extensions.
Hello @JonathanMagnan,
Thanks for answer. I tried to use BulkInsert + InsertIfNotExists, and it does not work as expected.
Could you please look in to the Fiddle, and figure out it?
Fiddle
https://dotnetfiddle.net/IY01fw
from entityframework-extensions.
Related Issues (20)
- 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 5
- Microsoft.Data.SqlClient is on a vulnerable version - security update HOT 1
- BulkInsert ignoring session context value set before insert HOT 3
- BulkInsert - ERROR_34 HOT 9
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.