Data returning an old value after an update statement

As Ak

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 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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
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 Ak4y ago
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.
Sachin Singh4y ago
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().