Replacing Entity in LINQ

Question

I'm using an Edit View in ASP.NET MVC and after an edit it returns the Edited Entity back. What's the best way to get the edited values back to the databse.

    [AcceptVerbs(HttpVerbs.Post)]
    public ActionResult Edit(int id, Movies EditedMovie)
    {
        var orginalMovie = _db_linq.Movies.First(e => e.Id == id);
        if (!ModelState.IsValid)
            return View(orginalMovie);

        _db_linq.Movies.Attach(EditedMovie, true);
        _db_linq.SubmitChanges();

        return RedirectToAction("Index");
    }

Returns the Error "Cannot add an entity with a key that is already in use."

orginalMovie = EditedMovie; doesn't work,too I have too copy each property seperate, i.e.

orginalMovie.Name = EditedMovie.Name;

Answer 1

For Entity Framework:

Change:

    _db_linq.Movies.Attach(EditedMovie, true);

to:

    _db_linq.Movies.ApplyPropertyChanges(EditedMovie);

Answer 2

I never used, but exists: http://msdn.microsoft.com/en-us/library/system.data.objects.objectcontext.applypropertychanges.aspx