Use Z Entity Framework Extensions or other tools for Bulk Commands
I need to insert ~100,000 records between data contexts from existing projects. This is something that only needs to be run for testing and migration, which is why i thought linqpad might be a good option. I wrote the logic in Linqpad and like the way it works, except that it takes a very long time to do the inserts. This turns out to be a problem because i need to lock production for the time it takes to migrate and validate the data.
If have a license for https://entityframework-extensions.net/ which is what i would normally use for bulk sql commands, but cannot figure out how to make it work in Linqpad.
I am hoping someone can point to a solution, even if the answer is that i should convert this project out of linqpad.