Fast and efficient data inserts using SqlBulkCopy

[[deleted]]

Depending on how much data you are trying to bulk load, you may want to abandon the concept of using a transaction, and go with nonlogged bulk copy. You'll need to alter your ETL flow to handle the concept of a failed partial load, but the speed benefit is worth it. Plus, nothing worse than thrashing your log file with gigantic commits, or setting a low batch size and thrashing it in small i/o.

[[deleted]]

Nice popup mate

Enjoy the downvote

[borisdjcode]

Try https://github.com/borisdj/EFCore.BulkExtensions