LinqToSql Plus 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.

context.BulkSaveChanges(options =>
   options.TemporaryTableInsertBatchSize = 50000;


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

Prime Library