Question SqlTransaction and Stored Procedure

[Viper]

Hi

I have an employee object that gets transported between the client and server application.

To retrieve the employee object from the server, I call a stored procedure called GetEmployee on the database and the object is constructed with the returned dataset.

Then, when I need to save the employee, I send the employee object to the server, a new SqlConnection is created and a SqlTransaction is started, and then a bunch of executions are done on the server side to save the employee. After that, the transaction is committed, then a new employee object is created from the database based (to include all the new IDs and so on) and that is then returned to the client. (so the object is saved and refreshed in one call).

The problem is, that when retrieving the new object directly after saving it, the old information (before being saved) is returned instead of the updated data. If I do a direct Select statement on the employees table, then the latest data is returned, but if I call the stored procedure, the old data is returned.

Any advice will be appreciated.

 

[Tom]

Are you sure your commiting the transaction before running your select?

 

[Viper]

Yes. The Select From Employees table works fine. It is when calling the stored procedure that the updated data doesn't get returned