SqlServerBulkOperationsDbSetting

A setting class used for the SQL Server data provider, extended with the settings of the bulk operations.

This class extends SqlServerDbSetting with the settings of the bulk operations (bulk-insert, bulk-merge, bulk-update and bulk-delete) for SQL Server, and inherits all of its configured values. Pass an instance to SqlServerGlobalConfiguration’s UseSqlServer method to register it in place of the default setting.

Properties

Name Description
BulkColumnMappingsBehavior Gets or sets the SqlServerBulkColumnMappingsBehavior value that defines how the columns of the source are aligned with the columns of the destination table when no explicit mappings were passed to a bulk operation. Explicit mappings always take precedence over this setting. The default value is Automatic.

Usability

GlobalConfiguration
    .Setup()
    .UseSqlServer(new SqlServerBulkOperationsDbSetting
    {
        BulkColumnMappingsBehavior = SqlServerBulkColumnMappingsBehavior.Strict
    });