The TdDataAdapter class supports Batch Updates. The Data Provider will send a Request to the Teradata Database 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 Teradata Database 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 Teradata Database.
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 Teradata Database
How Statement Independence Affects Batch Update
Behavior When Batch Updating with Different Settings
DbDataAdapter.Update
TdCommandBuilder
TdDataAdapter.UpdateBatchSize
TdDataAdapter.KeepCommandBatchSequence