Dapper Plus Temporary Table Options

Description

Dapper Plus Mapper allows configuring temporary table options.

TemporaryTableBatchByTable

Sets the number of batches a temporary table can hold. For example, configure the entity order to create a temporary table every five batches.

//Default
DapperPlusManager.MapperFactory = mapper => mapper.TemporaryTableBatchByTable(5);

//Instance
DapperPlusManager.Entity<Order>().TemporaryTableBatchByTable(5);

By default, only one temporary table is used.

TemporaryTableInsertBatchSize

Sets the batch size for inserting in the temporary table. For example, configure the entity order to insert in the temporary table in a batch of 50,000 entities.

//Default
DapperPlusManager.MapperFactory = mapper => mapper.TemporaryTableInsertBatchSize(50000);

//Instance
DapperPlusManager.Entity<Order>().TemporaryTableInsertBatchSize(50000);

The default value is 100,000.

TemporaryTableMinRecord

Sets the minimum number of records before using the temporary table strategy. For example, configure the entity order to use the temporary table only when inserting 50 or more entities

//Default
DapperPlusManager.MapperFactory = mapper => mapper.TemporaryTableMinRecord(50);

//Instance
DapperPlusManager.Entity<Order>().TemporaryTableMinRecord(50);

The default value is 10.

TemporaryTableSchemaName

Sets the temporary table schema name to use. For example, configure the entity order to create the temporary table in the "zzz" schema.

//Default
DapperPlusManager.MapperFactory = mapper => mapper.TemporaryTableSchemaName("zzz");

//Instance
DapperPlusManager.Entity<Order>().TemporaryTableSchemaName("zzz");

The default schema name is "dbo".

Provider Supported

• SQL Server
• SQL Azure