Saving changes/updating existing object in dataset with Entity FrameWork and not have to set each property individually

Question

Can I do something like the below (which does not work) without having to explicitly set each property of the object. Product is the object that is created by the default model binder from a form submission and ProductInDb is object in the context/database that I wish to override/update. The ProductID primary key is the same on both.

var ProductInDb = context.Products.FirstOrDefault(x => x.ProductID == product.ProductID);

ProductInDb = product;

context.SaveChanges();

Eranga · Accepted Answer · 2011-10-04 03:50:49Z

19

You can attach the existing product and set its state as Modified.

If you are using DbContext API

context.Products.Attach(product);
context.Entry(product).State = EntityState.Modified;

context.SaveChanges();

For ObjectContext

context.Products.Attach(product);
context.ObjectStateManager.ChangeObjectState(product, EntityState.Modified);

context.SaveChanges();

edited Oct 4, 2011 at 3:50

answered Oct 4, 2011 at 2:09

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

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

4 Comments

LaserBeak Over a year ago

Does not contain a definition for "Entry". Do I need to reference something ? Already using System.Data.Objects; What else ? Pressing ctrl + . gives nothing for Entry.

Eranga Over a year ago

@LaserBeak It looks like you are using ObjectContext. See my updated answer.

Elad Benda Over a year ago

@Eranga please see my following question: stackoverflow.com/questions/16085654/…

Elad Benda Over a year ago

@Eranga I have tried the same thing, but got uniquness violation error in the DB as I edit an already exiting entity. Maybe your syntax will help me.

Collectives™ on Stack Overflow

Saving changes/updating existing object in dataset with Entity FrameWork and not have to set each property individually

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related