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
– tede24, Commented Feb 25, 2016 at 4:07
you need to mark entitystate modified for user object only. — Vishal Sharma
– Vishal Sharma, Commented Feb 25, 2016 at 4:55

Dgan · Accepted Answer · 2020-07-21 17:25:25Z

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, 2020 at 17:25

Dgan

10.3k1 gold badge33 silver badges51 bronze badges

answered Feb 25, 2016 at 6:31

Uthman Rahimi

7087 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cheng Chen · Accepted Answer · 2016-02-25 03:51:35Z

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, 2016 at 3:51

Cheng Chen

43.7k18 gold badges118 silver badges184 bronze badges

1 Comment

Sangram Nandkhile Over a year ago

Why is it not accepted yet? less verbose and works well. +1

tede24 · Accepted Answer · 2016-02-25 10:21:07Z

1

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.

answered Feb 25, 2016 at 10:21

tede24

2,36414 silver badges14 bronze badges

Comments

JanMer · Accepted Answer · 2016-02-25 10:05:51Z

0

Try this,

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

                db.SaveChanges();
                return true;
            }

answered Feb 25, 2016 at 10:05

JanMer

1,2753 gold badges19 silver badges28 bronze badges

Comments

Seabizkit · Accepted Answer · 2016-02-25 11:47:56Z

0

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();

edited Feb 25, 2016 at 11:47

answered Feb 25, 2016 at 11:42

Seabizkit

2,4152 gold badges17 silver badges33 bronze badges

Comments

sagar jadhav · Accepted Answer · 2022-03-08 14:18:16Z

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 8, 2022 at 14:18

sagar jadhav

11 bronze badge

Collectives™ on Stack Overflow

Update multiple columns in Entity Framework

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related