temporary-table-use-table-lock

Definition

Gets or sets if the temporary table must be locked when inserting records into it.

Example

context.BulkSaveChanges(options =>
{
options.TemporaryTableUseTableLock = true;
});

Purpose

Using table lock increases the overall performance when inserting into a temporary table. This option should not be disabled.