IDBBatchConnection.ExecuteBatch Method
Executes a SQL DML statement as a native batch over multiple rows.
Syntax
Unit: Aurelius.Drivers.Interfaces
function IDBBatchConnection.ExecuteBatch(const SQL: string; Params: TEnumerable<TDBParam>; BatchSize: Integer): Integer; virtual; abstract;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | SQL | string | The SQL statement to execute for each row in the batch. |
| Params | TEnumerable<TDBParam> | The parameters for the statement. Each TDBParam must have its ParamValues array populated with one value per row. |
|
| BatchSize | Integer | The number of rows to process in the batch. |
Returns
The total number of rows affected.