Which SqlBulkCopy options should we use by default?
For common scenario:
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.