Gets or sets the number of rows in each batch. At the end of each batch, the rows in the batch are sent to the server.

Syntax

Visual Basic

Public Property BatchSize As Integer

C#

public int BatchSize  { get; set; }

Property value

The number of rows in each batch. The default is 0.

Remarks

Setting it to zero causes all the rows to be sent in one batch.

Setting it less than zero is an error.

If this value is changed while a batch is in progress, the current batch completes and any further batches use the new value.

See also

• ULBulkCopy class
• ULBulkCopy members