- Main Features
- Single Methods
- Column Options
- Bulk Options
- Batch Operations
-
Utilities
- Batch SaveChanges
- Delete ByKey
- Delete Range ByKey
- ToSelfHierarchyList
- BulkRead
- WhereBulkNotContains
- WhereBulkContainsFilterList
- WhereBulkNotContainsFilterList
- WhereExistsBulkInsert
- WhereNotExistsBulkInsert
- EF PostConfigurationCore - DbCommandInterceptor
- EF Core - DbConnectionInterceptor
- EF Core - DbTransactionInterceptor
- Articles
- Troubleshooting
- Release Notes
SqlBulkCopyOptions
Description
Gets or sets the SqlBulkCopyOptions to use when SqlBulkCopy is used to directly insert in the destination table.
context.BulkSaveChanges(options =>
{
options.SqlBulkCopyOptions = SqlBulkCopyOptions.Default | SqlBulkCopyOptions.TableLock;
});
Purpose
Modifying the SqlBulkCopyOptions to include for example TableLock may significantly increase performance.
Author: ZZZ Projects