How to update only one field using Entity Framework?

Question

Here's the table

Users

UserId

UserName

Password

EmailAddress

and code...

public void ChangePassword(int userId, string password){

//code to update the password...

}

Answer 1

Try the below code:

public void ChangePassword(int userId, string password)

{

  var user = new User() { Id = userId, Password = password };

  using (var db = new MyEfContextName())

  {

    db.Users.Attach(user);

    db.Entry(user).Property(x => x.Password).IsModified = true;

    db.SaveChanges();

  }

}