You use SqlDataAdapter to load a DataTable with rows from a Microsoft SQL Server database table. The table includes an identity column that is the primary key. You configure the adapter's InsertCommand to call a stored procedure that adds a new row that includes all table values except the identity column. You configure the adapter's UpdateCommand to call a stored procedure that updates a row based on the primary key column value.

When testing, you find that you can successfully call the adapter's Update method to add new DataTable rows to the database table. However, you find that when you then modify a column in one of these added DataTable rows and attempt to update the database table a second time, an exception is thrown. The exception indicates that the provided primary key column value was not found in the database. You must fix the problem.

What should you do?