Update multiple columns in Entity Framework

Question

I want to update multiple columns in Entity Framework. I now use this :

var user = new Relations { Id=1, Status = 1, Date = DateTime.Now, Notification = 0 };

db.Relations.Attach(user);

db.Entry(user).Property(x => x.Status).IsModified = true;
db.Entry(user).Property(x => x.Notification).IsModified = true;
db.Entry(user).Property(x => x.Date).IsModified = true;

db.Configuration.ValidateOnSaveEnabled = false;
db.SaveChanges();

Is there a better way to update columns without repeating the code db.Entry(user).Property several times ?

Is there any reason don't you simply set entry state as modified? — tede24, Feb 25 '16 at 04:07
you need to mark `entitystate` modified for `user` object only. — Vishal Sharma, Feb 25 '16 at 04:55

score 5 · Accepted Answer · edited Jul 21 '20 at 17:25

5

you can Use EntityState Like this:

var user=db.users.Find(userId);
user.name="new name";
user.age=txtAge.text;
user.address=txtAddress.text;
context.Entry(user).State=Entitystate.Modified;

edited Jul 21 '20 at 17:25

Dgan

10,077
1
29
51

answered Feb 25 '16 at 06:31

Uthman Rahimi

708
5
22

score 1 · Answer 2 · answered Feb 25 '16 at 03:51

1

I prefer use:

var existingUser = context.Set<User>().Where(u => u.Id == 1);
context.Entry(existingUser).CurrentValues.SetValues(user);

Or you can use a 3rd lib like GraphDiff.

answered Feb 25 '16 at 03:51

Cheng Chen

42,509
16
113
174

Why is it not accepted yet? less verbose and works well. +1 – Sangram Nandkhile Aug 05 '17 at 19:24

score 1 · Answer 3 · answered Feb 25 '16 at 10:21

Yo update an entity you don't need to do this:

// build your entity object with new values
var user = new Relations { Id=1, Status = 1, Date = DateTime.Now, Notification = 0 };
//attach as modified in one single step
db.Entry(user).State = EntityState.Modified;
//execute update
db.SaveChanges();

This assumes you are setting all entity fields and there isn't RowVersion field in your entity. Extra steps would be required to manage these other situations.

score 0 · Answer 4 · answered Feb 25 '16 at 10:05

Try this,

using (var db = new YourDb())
            {
                try
                {
                    db.Entry(user).State = EntityState.Modified;
                }
                catch (Exception)
                {
                    return false;
                }

                db.SaveChanges();
                return true;
            }

Seabizkit · Answer 5 · 2016-02-25T11:47:56.887

When an item is fetched via the context it is

automatically tracked in that context unless you change the default behavior.

So you could simple do:

var txtInputAge = 18;
var txtAdrressLine1 = "Some cool place"

//fetch the user
var user = db.Users.Find(userId);

//change the properties
user.Name = "new cooler name";
user.Age = txtInputAge;
user.Address = txtAdrressLine1;

//call save changes
db.SaveChanges();

Update - Add would look like

//create new entry
User user = new User();

user.Name = "new cooler name";
user.Age = txtInputAge;
user.Address = txtAdrressLine1;

//add to context
db.Users.Add(user);

//call save changes
db.SaveChanges();

score 0 · Answer 6 · answered Mar 08 '22 at 14:18

0

using (var dbcontext = new MyModel()) {

var matchedRecords = dbcontext.DummyTable.Where(e => e.code.Equals(entry.code) &&
e.isValid.Equals(true)).ToList();
matchedRecords.ForEach(e => e.isValid = false);
dbcontext.SaveChanges();

}

answered Mar 08 '22 at 14:18

sagar jadhav

1
1

Update multiple columns in Entity Framework

6 Answers6

Linked