N.EntityFrameworkCore.Extensions icon indicating copy to clipboard operation
N.EntityFrameworkCore.Extensions copied to clipboard

Add support for Entity Graph to Bulk Insert.

Open davidcorbin-atmosera opened this issue 1 year ago • 2 comments
trafficstars

Is your feature request related to a problem? Please describe. It is quite challenging when there is a complex relationship between entities to get all of the PK->FK correct, and a large part of this is doing the insets "in the right order" as well as post-patching certain things..

Describe the solution you'd like A clear and concise description of what you want to happen.

Describe alternatives you've considered Using a regular DbContext and DbSets with single operations works using standard EF.

Additional context Other (paid) extensions seem to have this capabilitity..

davidcorbin-atmosera avatar Jun 19 '24 10:06 davidcorbin-atmosera

@davidcorbin-atmosera,

The lack of graph support for all bulk operations was intentional because amount of work involved with adding that feature, though it could be considered in the future.

I will keep this issue open as I evaluate the amount of effort to implement this feature.

NorthernLight1 avatar Jun 19 '24 20:06 NorthernLight1

Yeah, quite a bit.... the gotcha [just as an FYI] is I am migrating a very old and very slow system. So much of the time is in "one by one" but at the same time modifications transcend an object graph of about 40 different types, and no clear order in which to bulk save (I am not sure there is one directed-graph that covers all bases, it is easy to get lost)...

Fell free to close or what ever process you feel is appropriate to follow for this item.

davidcorbin-atmosera avatar Jun 19 '24 20:06 davidcorbin-atmosera

I am closing this item, but it may be considered in a future version

NorthernLight1 avatar Aug 27 '24 17:08 NorthernLight1