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

The TdDataAdapter.KeepCommandBatchSequence property is used to indicate that the order the DataRows were updated will be kept when the data is sent to the Advanced SQL Engine. For example, suppose KeepCommandBatchSequence has been set to true and the following actions were performed on a DataTable:

  1. DataRow #2 was deleted.
  2. A new DataRow was added.

The SQL statements that will be sent to the Advanced SQL Engine will be in the order of: DELETE, INSERT.

By default this property is set to false.