CODEWITHSUNDEEP
c#asp.netasp.net-mvc
User89
User89

Reputation: 113

Null on updated fields

I am trying to update one single field in a table but it's giving me an error saying that the other content is null. I'm trying to update one single field from a table and leave the other fields as they were.

Code so far:

  var user = new User() { CardNumber = cardNumber };
  using (var db = new Entities())
  { 
     db.Users.Attach(user);
     db.Entry(user).Property(x => x.CardNumber).IsModified = true;
     db.Configuration.ValidateOnSaveEnabled = false;
     db.SaveChanges();
  }

Upvotes: 0

Views: 45

Answers (1)

David James Smith
David James Smith

Reputation: 81

Here is a code example to update the card number and save it.

using (var db = new Entities())
{
   User user = db.Users.Where(u => u.Id == userIdToBeUpdated).FirstOrDefault();
   user.CardNumber = cardNumber;
   db.SaveChanges();
}

Upvotes: 2

Related Questions