Specifies the maximum number of rows included in each batch submitted during batch operations.

Data Type

int

Default Value

0

Remarks

When BatchSize is set to a value greater than 0, the provider splits the entire operation into smaller batches, each containing the number of rows specified by the BatchSize property. These smaller batches are submitted to the server one at a time.

When set to 0, the provider submits the entire batch as a single request.

BatchSize is useful in situations where the server imposes limits on the size of requests. By splitting the operation into smaller parts, you can work around these limitations and ensure successful batch processing.