search

paillave / Etl.Net

Mass processing data with a complete ETL for .net developers
https://paillave.github.io/Etl.Net/
MIT License
668 stars 92 forks source link

added fluent WithIdentityInsert() method in order to deactivate and reactivate Identity insert in an sql database. Added a test project using TestContainers #468

Open FrancisGauthier opened 1 year ago

FrancisGauthier commented 1 year ago

added fluent WithIdentityInsert() with EFSave method in order to deactivate and reactivate Identity insert in an sql database.

added a test project with a test container to run an actual sql server for testing purposes.

Requires docker installed

Need to add test executions in the pipeline/workflow. This can be added in another PR or within this one.

FrancisGauthier commented 4 months ago

Hi, its been a while the pr is open. I rebased the code and reverted some code i accidentally pushed in my fork.

Let me know if i can help with anything else. I think this would be a nice addition to this library. We do use that library for a custom ETL in a project and keeping the identity ids is really helpfull. Otherwise we have to disable and reenable identity columns before and after ETL processes

Thanks,