The TdDataAdapter cannot return identity columns for insert statements to the DataTable when the batch update is enabled. It is necessary to set the TdCommand.UpdatedRowSource property to OutputParameters
to return updated identity columns for insert statements, however the Teradata Database does not support Stored Procedures in multi-statement or iterated requests used when batch updates are enabled (How SQL Statements Are Sent to the Teradata Database). The ADO.NET specification (Performing Batch Operations Using DataAdapters) states that the command's UpdatedRowSource property values None
and OutputParameters
are the only valid values when performing a batch update.