Update rows from included table

Asked May 13 '18 at 10:50

Active May 13 '18 at 12:28

Viewed 43 times

I use EF 6. I select row from the users table and use .Include to also get the address (etc...). Now I want update that address data.

How can I do it?

This code updates only the users table:

var MyUser = db.Users.Include(b => b.Address)
                     .Where(x => x.MISPAR_ZIHUY.Equals(123456))
                     .FirstOrDefault();
db.Users.Attach(MyUser);
db.Entry(MyUser).State = EntityState.Modified;
db.Entry(MyUser).CurrentValues.SetValues(MyNewUser);
db.SaveChanges();

edited May 13 '18 at 10:59

asked May 13 '18 at 10:50

user1012506

2,048
1
26
45

var MyUser= db.Users.Select(b => b.Address).Where(x => x.MISPAR_ZIHUY.Equals(123456)) That if i understand your question right – Aya Abdelaziz May 13 '18 at 10:53
db.Users has an AcceptChanges() method which writes data back to the database. – jdweng May 13 '18 at 10:57
aya-abdelaziz - Did you mean remove .FirstOrDefault() ? – user1012506 May 13 '18 at 11:00
jdweng - I use SaveChanges() – user1012506 May 13 '18 at 11:02
i mean use Select instead of include to select all address – Aya Abdelaziz May 13 '18 at 11:05
But I need to get also the dependency tables of users and update them. – user1012506 May 13 '18 at 11:11
1

I think this is a duplicate issue. (see https://stackoverflow.com/questions/13236116/entity-framework-problems-updating-related-objects) If you want to set nested entities (I.e. addresses within a User) based on the provided modified set, you need to call SetValues() on each nested entity. – Steve Py May 14 '18 at 03:00
Because I want to replace MyUser with MyNewUser – user1012506 May 14 '18 at 09:34

Update rows from included table

0 Answers0