LinqToSql Plus SqlBulkCopyOptions

Description

Gets or sets the SqlBulkCopyOptions to use when SqlBulkCopy is used to directly insert in the destination table.

context.BulkSaveChanges(options =>
{
   options.SqlBulkCopyOptions = SqlBulkCopyOptions.Default | SqlBulkCopyOptions.TableLock;
});

Purpose

Modifying the SqlBulkCopyOptions to include by example TableLock may increase significantly the performance.