Table of Contents

Class BulkInsertSettings

Namespace
CMS.DataEngine
Assembly
CMS.DataEngine.dll

Configuration class for BulkInsert(DataTable, string, BulkInsertSettings).

public class BulkInsertSettings
Inheritance
object
BulkInsertSettings
Extension Methods

Constructors

BulkInsertSettings()

Default constructor.

public BulkInsertSettings()

Properties

BatchSize

Number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server. A value of 0 indicates that batches won't be used.

public int BatchSize { get; set; }

Property Value

int

BulkCopyTimeout

Number of seconds for the operation to complete before it times out. The default is 30 seconds. A value of 0 indicates no limit; the bulk copy will wait indefinitely.

public int BulkCopyTimeout { get; set; }

Property Value

int

KeepIdentity

Gets or sets whether to keep identity of inserted data.

public bool KeepIdentity { get; set; }

Property Value

bool

Mappings

Gets or sets a collection of column mappings. Column mappings define the relationships between columns in the data source and columns in the destination.

public IDictionary<string, string> Mappings { get; set; }

Property Value

IDictionary<string, string>

Options

Gets or sets a bitwise flag that specifies one or more options to use with an instance of Microsoft.Data.SqlClient.SqlBulkCopy.

public SqlBulkCopyOptions Options { get; set; }

Property Value

SqlBulkCopyOptions