MikaelEliasson / EntityFramework.Utilities

Provides extensions for EntityFramework that doesn't exist out of the box like delete and update by query and bulk inserts
443 stars 176 forks source link

Batch Update doesn't work with table schema. #122

Open amazontest opened 6 years ago

amazontest commented 6 years ago

I tried to use Batch update but it doesn't work with table schema. I am using database first model and i annotated my Schema class but update query i see in profiler without schema.

sebastian-ilari commented 6 years ago

I am having the same issue.

Using SQL Profiler I can see that it creates the temp table in the schema but on the last step it ignores the schema when applying the UPDATE back to the main table.

RudeySH commented 6 years ago

There are numerous pending pull requests that fix this issue. Unfortunately this repository is dead. I am maintaining a fork of EntityFramework.Utilities, which can be found here. In my fork I have merged most useful pending pull requests. It includes a fix for the table schema problem. I don't have a NuGet package for it yet, so if you want to use it you'll have to download the project and build the DLL file yourself.

sebastian-ilari commented 6 years ago

Thanks for the advise Rudey, I knew this repo was kind of dead. Such a shame because it is such a great tool.

I will see if I can use your fork.

RudeySH commented 6 years ago

There is now a NuGet package of my fork available here: https://www.nuget.org/packages/RudeySH.EFUtilities/