Databases
StackOverflow2013
Postsdbo
POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
    primarykey
    data
    text
    <p>I'm building a MVC3 project, using Razor and Entity Framework code first. I have two models:</p> <pre><code>public class Translation { public int TranslationId { get; set; } public string Pt { get; set; } public string Es { get; set; } public string En { get; set; } } public class Page { public int PageId { get; set; } public Translation Title { get; set; } public Translation Description { get; set; } public int? ParentPageId { get; set; } // page can have a parent page public Page ParentPage { get; set; } } </code></pre> <p>I created the PagesController for CRUD for the Page model. Then I edited the Create and Edit views adding inputs for the Translation properties:</p> <pre><code>&lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Title.Pt) @Html.ValidationMessageFor(model =&gt; model.Title.Pt) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Title.Es) @Html.ValidationMessageFor(model =&gt; model.Title.Es) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Title.En) @Html.ValidationMessageFor(model =&gt; model.Title.En) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Description.Pt) @Html.ValidationMessageFor(model =&gt; model.Description.Pt) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Description.Es) @Html.ValidationMessageFor(model =&gt; model.Description.Es) &lt;/div&gt; &lt;div class="editor-field"&gt; @Html.EditorFor(model =&gt; model.Description.En) @Html.ValidationMessageFor(model =&gt; model.Description.En) &lt;/div&gt; </code></pre> <p>It works well on Create, adding two new lines to the Translations table (one refered by Title_TranslationId and the other Description_TranslationId) with the input contents. But when Updating, I get the mentioned error at line:</p> <pre><code>db.Entry(page).State = EntityState.Modified; </code></pre> <p>The PagesController is as it was created, so no extra attaches are being made. If I delete one of the Translations inputs at the Edit view, it doesn't throw the error, but doesn't update the translations anyway. </p> <p>The PagesController code:</p> <pre><code>private AdminEntities db = new AdminEntities(); public ViewResult Index() { return View(db.Pages.ToList()); } public ViewResult Details(int id) { Page page = db.Pages.Find(id); return View(page); } public ActionResult Create() { ViewBag.ParentPageId = new SelectList(db.Pages, "ParentPageId", "Description"); return View(); } [HttpPost] public ActionResult Create(Page page) { if (ModelState.IsValid) { db.Pages.Add(page); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.ParentPageId = new SelectList(db.Pages, "ParentPageId", "Description", page.ParentPageId); return View(page); } public ActionResult Edit(int id) { Page page = db.Pages.Find(id); ViewBag.ParentPageId = new SelectList(db.Pages, "ParentPageId", "Description", page.ParentPageId); return View(page); } [HttpPost] public ActionResult Edit(Page page) { if (ModelState.IsValid) { db.Entry(page).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.ParentPageId = new SelectList(db.Pages, "ParentPageId", "Description", page.ParentPageId); return View(page); } } </code></pre> <p>Note that ViewBag.ParentPageId feeds a Pages list that i didn't include in the view code, because it works if I remove the Translation stuff.</p> <p>Any ideas?</p> <p>EDIT: Maybe it is too complicated for EF to handle? Maybe I should change my aproach.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USnoinstance
    1. USnoinstance
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you post the edit controller code?
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. USTridus
    2. COjust edited, thanks.
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. USnoinstance
    3. COYou need to declare properties in your model classes as virtual
      singulars
      1. POEntity Framework "An object with the same key already exists in the ObjectStateManager." - I can't understand how, or what to do from here
      1. USJayantha Lal Sirisena
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload