The TdDataAdapter class supports Batch Updates. The Data Provider will send a Request to the Advanced SQL Engine containing multiple SQL-Statements corresponding to the changes made to the DataRows of the DataTable.
When the DbDataAdapter.Update method is invoked, the TdCommandBuilder will generate SQL statements based upon the action (Create, Update or Delete) performed on each DataRow. The Data Provider will send these SQL-Statements to the SQL Engine so that the rows in the corresponding table will get updated. Several of these SQL-Statements can be batched together in one Request sent to the SQL Engine.
The some key properties that affect the batch update are:
Continue Processing When Error Occurs
Keeping the Command Batch Sequence
How SQL Statements Are Sent to the Advanced SQL Engine
How Statement Independence Affects Batch Update
Behavior When Batch Updating with Different Settings
DbDataAdapter.Update
TdCommandBuilder
TdDataAdapter.UpdateBatchSize
TdDataAdapter.KeepCommandBatchSequence