Entity Framework Extensions 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 for example TableLock may increase significantly the performance.


Last updated: 2023-03-01
Author:


Contents