Temporary Table


TemporaryTableBatchByTable

Gets or sets the number of batches a temporary table can contain. This option may create multiple temporary tables when the number of batches to execute exceed the limit specified.

Read more: TemporaryTableBatchByTable

Example

context.BulkSaveChanges(options =>
{
   options.TemporaryTableBatchByTable = 0; // unlimited
});

TemporaryTableInsertBatchSize

Gets or sets the number of records to use in a batch when inserting in a temporary table. This number is recommended to be high.

Read more: TemporaryTableInsertBatchSize

Example

context.BulkSaveChanges(options =>
{
   options.TemporaryTableInsertBatchSize = 50000;
});

TemporaryTableMinRecord

Gets or sets the minimum number of records to use a temporary table instead of using SQL derived table.

Read more: TemporaryTableMinRecord

Example

context.BulkSaveChanges(options =>
{
   options.TemporaryTableMinRecord = 25;
});

TemporaryTableSchemaName

Gets or sets the schema name to use for the temporary table.

Read more: TemporaryTableSchemaName

Example

context.BulkSaveChanges(options =>
{
   options.TemporaryTableSchemaName = "zzz";
});

TemporaryTableUseTableLock

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

Read more: TemporaryTableUseTableLock

Example

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

UsePermanentTable

Gets or sets if the library should create and drop a permanent table instead of using a temporary table.

Read more: UsePermanentTable

Example

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