SqlBulkCopy - Recommended SqlBulkCopyOptions | sqlbulkcopy Tutorial

Download SqlBulkCopy (PDF)

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9

Question

Which SqlBulkCopy options should we use by default?

Answer

For common scenario:

CheckConstraints
FireTrigger

var options = SqlBulkCopyOptions.CheckConstraints | SqlBulkCopyOptions.FireTriggers | SqlBulkCopyOptions.TableLock;

By default, all options are turned off which is very bad.

Even if your table doesn't yet have a constraint or trigger you need know what could happen in a year.

Still not sure about which default option to use?

Talk to your team
Agreed on which default options to use within the company
Stick with it unless you have a special scenario

Get monthly updates about new articles, cheatsheets, and tricks.