Send feedback on this topic.
Teradata.Client.Provider
Batch Update
.NET Data Provider for Teradata > Developer's Guide > Working with the Data Provider Features > TdCommandBuilder and TdDataAdapter Overview > Batch Update

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:

In This Section

Working with Batch Size

Continue Processing When Error Occurs

Keeping the Command Batch Sequence

How SQL Statements Are Sent to the Advanced SQL Engine

Identity Columns

How Statement Independence Affects Batch Update

Behavior When Batch Updating with Different Settings

See Also

DbDataAdapter.Update
TdCommandBuilder
TdDataAdapter.UpdateBatchSize
TdDataAdapter.KeepCommandBatchSequence