Error while updating Database record with Entity Framework on ASP.NET MVC Page

Question

I have an ASP.NET Page that updates registered User Address Details for a selected record.

Below is the update method that I am calling from my controller.

When I am calling the ApplyPropertyChanges method, I am getting an error. Did anyone run into the same error while updating the record with Entity Framework?

Appreciate your responses.

Error message:

The existing object in the ObjectContext is in the Added state. Changes can only be applied when the existing object is in an unchanged or modified state.

My Update method:

[HttpPost]
public bool UpdateAddressDetail([Bind(Prefix = "RegUser")] AddressDetail regUserAddress, FormCollection formData)
{
    regUserAddress.AD_Id = 3;
    regUserAddress.LastUpdated = HttpContext.User.Identity.Name;
    regUserAddress.UpdatedOn = DateTime.Now;
    regUserAddress.AddressType = ((AddressDetail)Session["CurrentAddress"]).AddressType ?? "Primary";
    regUserAddress.Phone = ((AddressDetail)Session["CurrentAddress"]).Phone;
    regUserAddress.Country = ((AddressDetail)Session["CurrentAddress"]).AddressType ?? "USA";

    miEntity.ApplyPropertyChanges(regUserAddress.EntityKey.EntitySetName, regUserAddress);

    miEntity.SaveChanges();

    return true;
}

I explained the same problem in slightly different way here: stackoverflow.com/questions/2443062/… The main reason is that there is a TypeConverter that ends up adding State (which is an entity / lookup table) to the address, and that moves Address object from Detached to Added state. And now it is impossible to ApplyPropertyChanges or Attach the wrongfully added Address. It works fine if, instead of using TypeConverter, one assigns EntityReference in the controller itself. so - is it possible to avoid adding the object? — Felix
– Felix, Commented Mar 16, 2010 at 2:18

Brian Mains · Accepted Answer · 2010-03-12 19:57:42Z

1

The error is the object is detached from the context, and ApplyPropertyChanges thinks the object is added because it isn't attached. So you would need to query from the data context or get an attached form and then apply the changes then.

HTH.

answered Mar 12, 2010 at 19:57

Brian Mains

50.8k35 gold badges155 silver badges260 bronze badges

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

Comments

John Farrell · Accepted Answer · 2010-03-12 22:21:11Z

1

What Dave Said

+

You need to Attach() the disconnected entity to your object context:

http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.attach.aspx

miEntity.Attach(regUserAddress);
miEntity.SaveChanges();

answered Mar 12, 2010 at 22:21

John Farrell

24.7k10 gold badges82 silver badges112 bronze badges

2 Comments

John Farrell Over a year ago

Are you sure the record is in the database? What is AD_id? The PK?

Rita Over a year ago

Yes. There is this record in the database.

Jack · Accepted Answer · 2012-11-06 19:48:43Z

0

Just add the following code before miEntity.SaveChanges():

miEntity.Entry(regUserAddress).State = EntityState.Modified;

edited Nov 6, 2012 at 19:48

Jack

11k13 gold badges52 silver badges65 bronze badges

answered Nov 16, 2011 at 3:27

Diablo

1

Comments

marc_s · Accepted Answer · 2017-10-12 13:19:38Z

0

First select the record (object entity), search by key through the ObjectContext. For example if the search ArticleSet EntitySet called for there to record, and once you get it modified its properties with new values and then call SaveChanges() of ObjectContext.

Example:

ObjectQuery<Article> myArt=Context.ArticleSet.Where myArt = (row => row.ArticleId == value);
myArt.Description=" new value ";
etc. ..
etc ...

Context.SaveChanges ();

edited Oct 12, 2017 at 13:19

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Apr 16, 2010 at 19:27

Claudio

1

Collectives™ on Stack Overflow

Error while updating Database record with Entity Framework on ASP.NET MVC Page

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related