I have a project that has been upgraded from .Net 1.1 to 2.0 and I cannot get the UpdateRowSource.FirstReturnedRecord of the InsertCommand to work correctly using the System.Data.OracleClient. It works correctly on 1.1 and the DataSet is updated correctly after a DataAdapter.Update, but although the insert happens to the database on 2.0, the DataSet is not updated.
My InsertCommand is a stored procedure that gets the next id (primary key) for the tables instance, inserts the new record with the id, and then gets the newly inserted row as an output.
The expected behaviour is the DataSet I passed into the Update method is returned with the record containing the new id.
Has anybody run into this problem and found a work-around?