This property specifies a value that enables or disables batch processing support, and specifies the number of SQL statements that can be executed in a single round-trip to the database.
Declaration
// C#
public virtual int UpdateBatchSize {get; set;}
Property Value
An integer that returns the batch size.
Exceptions
ArgumentOutOfRangeException - The value is set to a number < 0.
Remarks
Update batches executed with large amounts of data may encounter an "PLS-00123: Program too large" error. To avoid this error, reduce the size of UpdateBatchSize to a smaller value.
For each row in the DataSet that has been modified, added, or deleted, one SQL statement will be executed on the database.
Values are as follows:
Value = 0
The data adapter executes all the SQL statements in a single database round-trip
Value = 1 - Default value
This value disables batch updating and SQL statements are executed one at a time.
Value = n where n > 1
The data adapter updates n rows of data per database round-trip.