The TdDataAdapter and TdCommandBuilder implement ADO.Net interfaces and overrides methods of base classes inherited from the .Net Framework. These methods are invoked by the .NET Framework when processing the data of a DataTable. In the implementation of the TdDataAdapter and TdCommandBuilder some workarounds had to be made due to the behavior of the Framework. Most of these workarounds are internal to the Teradata provider and are of no concern to applications.
Unfortunately, there are a few behaviors where a workaround could not be internally implemented in the provider. In these situations the coding of a workaround will need to be performed in the application. The following sections guidelines are given on how to address these issues. The issue is explained, an example is shown, and guidelines are given on how an application can workaround the issue.
Guideline for Efficiently Processing Batches
Attempting to insert a Null value into an Identity column
Inserting Into A Column Defined As NOT NULL with a DEFAULT value
Inserting LOB Column with a Stream/TextReader