Databases
StackOverflow2013
Postsdbo
POEF4 c# updating nested object in 1:n
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEF4 c# updating nested object in 1:n
    primarykey
    data
    text
    <p>I have an nested EF object hanging on its parent. It has 1:n relationship</p> <p>[parent]-[n..child]</p> <p>the nested object child is dynamic and will be updated through GUI.</p> <p>i have problem to updating it on database. </p> <p><strong>Error message:</strong> <em>An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key.</em></p> <p>this is question is 2nd version. i made a correction on if block for deciding preExist</p> <p>Thanks in advance for your help</p> <p>sittingduck</p> <p>Update on Main</p> <pre><code>void MainUpdate { var context = new FamilyEntities(); parent = getParentFromGui(); parent.UpdateRelatedEntities(context); context.dispose(); } </code></pre> <p>the object parent was updated in Gui</p> <pre><code>parent getParentFromGui() { parent myParent = parentBindingSource.DataSource as parent; foreach(child c in childrenBindingSource) { myParent.children.Add(c); } return myParent } </code></pre> <p>Modified UpdateRelatedEntities</p> <pre><code>public static void UpdateRelatedEntities(this parent entity, FamilyEntities context) { if (entity == null) return; var res = context.parent.Where(x =&gt; x.uid_parent == entity.uid_parent); var rec = res.FirstOrDefault(); context.parent.Attach(rec); context.parent.ApplyCurrentValues(entity); foreach (var c in entity.children) { bool preExist = context.children.FirstOrDefault(x =&gt; x.child_uid == c.child_uid); if (preExist != null) { context.children.Attach(obj); context.children.ApplyCurrentValues(c); } else { // This Part throw ERROR context.children.AddObject(c); } } context.SaveChanges(); } </code></pre> <p>What i'm doing wrong? </p> <p>Tx alot!</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsittingduck
    1. USsittingduck
    plurals
    1. This table or related slice is empty.
    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
    1. This table or related slice is empty.
    1. COWhat's the context.shaft_section? Does this garanties that the child isn't in the children collection?
      singulars
      1. POEF4 c# updating nested object in 1:n
      1. USAlexandre Rondeau
    2. COups sorry, it should be childrend. Thanks for correction
      singulars
      1. POEF4 c# updating nested object in 1:n
      1. USsittingduck
    3. CONow you are checking if a collection equals an item in the collection. This should always be false. Something like context.children.Any(x => x.child_uid == c.child_uid) should probably work
      singulars
      1. POEF4 c# updating nested object in 1:n
      1. USAlexandre Rondeau
 

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