Data returning an old value after an update statement

Question

Hi, I've an update statement to update a column in the database. However, after I update the value, when I try to retrieve the data, its returning an old value.

public override async Task<UserDetail> Retrieve (UserTable user)

query = "UPDATE users SET address1 = 'Mumbai' WHERE user_id = @user_id"
var sql = oVal.Db().OpenReader(query);

Console.WriteLine(user.address1);

How to get the current value after the data is being updated in the database?

Thank you in advance.

Sachin Singh · Answer

It depends on how are you retrieving the value. If you have another method to retrieve the records by userId then after updating the record simply call that method. If you don't have any method, then your update statement should return the updated column value as output column or the complete row. please explain what are you doing in this line. What is user and how do you get this data? user . address1 // This is just your parameter so you are getting old value. update table set column=@value where id=@Id; select column where id=@Id until you don't retrieve the value you won't get it. This is not Entity Framework where you get updated value after SaveChanges().

Sachin Singh · Answer

Which Data Access technology are you using? NHibernate/ADO.NET or something other? For Ado.Net public Task Update(UserTable user) { UserTable updateduser= new UserTable(); using (SqlConnection con= new SqlConnection(cs)) { SqlCommand cmd= new SqlCommand( "update users set address=@Address" where user_id=@userId,con); cmd.Parameters.AddWithValue( "@Address" ,user.Address); cmd.Parameters.AddWithValue( "@userId" ,user.UserId); con.Open(); SqlDataReader rdr=cmd.ExecuteReader(); while (rdr.Read()) { updateduser.Address=rdr[ "Address" ].ToString(); updateduser.UserName=rdr[ "UserName" ].ToString(); } return updateduser; } } public override async Task Retrieve (UserTable user) { var user=await Update(user); Console . WriteLine ( user . Address ) ; }

As Ak · Answer

i need to update the address1 column for certain user id. And need to retrieve the latest data from the database. Might be i need to insert the refresh database function to get the latest data. But im not sure how to do this.