Entity Framework Extensions TemporaryTableInsertBatchSize

Description

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.

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

Purpose

Increasing the default value may improve the performance. Since the temporary table doesn't contain indexes and triggers and it's normally locked during the insert, you may use a very high value.


Last updated: 2025-06-24
Author:


Contents