.NET Bulk Operations SQL Server

SQL Server Options

• SqlBulkCopyOptions

SqlBulkCopyOptions

Allow you to set the SqlBulkCopyOptions to use when a strategy with the SqlBulkCopy is selected.

Example

var bulk = new BulkOperation(connection);

bulk.SqlBulkCopyOptions = SqlBulkCopyOptions.Default | SqlBulkCopyOptions.TableLock;

bulk.BulkMerge(dt);