Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity attachment issues in LINQ

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.

like image 496
changelog Avatar asked Feb 11 '09 11:02

changelog


2 Answers

Try following:

dataContext.People.Attach(person);
dataContext.Refresh(RefreshMode.KeepCurrentValues, person);
dataContext.SubmitChanges();
like image 158
Roman O Avatar answered Oct 18 '22 20:10

Roman O


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.

like image 24
Benjamin Autin Avatar answered Oct 18 '22 20:10

Benjamin Autin