When the OdbcDataAdapter.DeleteCommand property is assigned to a previously created System.Data.Odbc.OdbcCommand, the System.Data.Odbc.OdbcCommand is not cloned. Instead, the OdbcDataAdapter.DeleteCommand maintains a reference to the previously created System.Data.Odbc.OdbcCommand.

During an update operation, if OdbcDataAdapter.DeleteCommand is not set and primary key information is present in the System.Data.DataSet, you can use the System.Data.Odbc.OdbcCommandBuilder class to automatically generate the OdbcDataAdapter.DeleteCommand, and additional commands needed to reconcile the System.Data.DataSet to the data source. To do this, set the OdbcDataAdapter.SelectCommand property of the System.Data.Odbc.OdbcDataAdapter. The generation logic also requires key column information to be present in the System.Data.DataSet. For more information, see Automatically Generating Commands.