I am trying to attach a LINQ entity to the data context after I receive it from a form POST. However, all I get is the following exception:
An entity can only be attached as modified without original state if it declares a version member or does not have an update check policy.
I have also tried attaching the original row, like so:
dataContext.People.Attach(person, originalPerson);
In this case, I get the following exception:
Object reference not set to an instance of an object.
Here's the code in my controller:
[AcceptVerbs(HttpVerbs.Post)]
public ActionResult Edit(int id, Person person) {
var prevPerson = dataContext.People.Single(p => p.ID == id);
dataContext.People.Attach(person, prevPerson);
dataContext.SubmitChanges();
return Redirect("~/People/Index");
}
Any ideas on what I'm doing wrong here? I can post the entity code if needed.
Try following:
dataContext.People.Attach(person);
dataContext.Refresh(RefreshMode.KeepCurrentValues, person);
dataContext.SubmitChanges();
In the LinqToSQL designer set all of the Update Checks to Never and when you attach call it like so:
context.entity.Attach(entity, true);
Alternatively, you could also grab the entity from the db and change it using the data from the POSTed entity, then submit that as a change.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With