DevForce Community Forum : ImportEntities can't find related 1..0 or 1 entity http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : ImportEntities can't find related 1..0 or 1 entity Wed, 29 Apr 2026 00:52:21 -700 Mon, 28 Dec 2009 13:42:20 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1594 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ ImportEntities can't find related 1..0 or 1 entity : The PK for DealCost should be... http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5995#5995 Author: davidklitzke
Subject: 1594
Posted: 28-Dec-2009 at 1:42pm

The PK for DealCost should be the same value as the PK for Deal, and I’m not sure why it’s 0.  If you do something like the following:

  Deal deal = em.CreateEntity<Deal>();

 // … set deal property values

Ddeal.AddToManager();

  DealCost dealCost = em.CreateEntity<DealCost>();

  dealCost.Deal = deal;

  // … set other dealCost values

  dealCost.AddToManager();

… then deal.DealId should equal dealCost.DealId.  Since it doesn’t – can we see the code snippet for how these entities are created to see what might be going wrong?

 

]]> Mon, 28 Dec 2009 13:42:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5995#5995 ImportEntities can't find related 1..0 or 1 entity : &lt;AssociationSet Name=&#034;Deal_DealCostSet&#034;... http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5979#5979 Author: skingaby
Subject: 1594
Posted: 23-Dec-2009 at 9:45am

<AssociationSet Name="Deal_DealCostSet" Association="Png.GcsAg.Model.ServerModelEF.Deal_DealCost">

     <End Role="Deal" EntitySet="Deals" />

     <End Role="DealCost" EntitySet="DealCosts" />

</AssociationSet>

            

In Deal:            

<NavigationProperty Name="DealCost" Relationship="Png.GcsAg.Model.ServerModelEF.Deal_DealCost" FromRole="Deal" ToRole="DealCost" />

          

In DealCost:          

<NavigationProperty Name="Deal" Relationship="Png.GcsAg.Model.ServerModelEF.Deal_DealCost" FromRole="DealCost" ToRole="Deal" />

            

<Association Name="Deal_DealCost">

     <End Role="Deal" Type="Png.GcsAg.Model.ServerModelEF.Deal" Multiplicity="1">

          <OnDelete Action="Cascade" />

     </End>

     <End Role="DealCost" Type="Png.GcsAg.Model.ServerModelEF.DealCost" Multiplicity="0..1" />

     <ReferentialConstraint>

     <Principal Role="Deal">

       <PropertyRef Name="DealId" />

     </Principal>

     <Dependent Role="DealCost">

       <PropertyRef Name="DealId" />

     </Dependent>

     </ReferentialConstraint>

</Association>

          

<AssociationSetMapping Name="Deal_DealCostSet" TypeName="Png.GcsAg.Model.ServerModelEF.Deal_DealCost" StoreEntitySet="DEAL_COSTs">

     <EndProperty Name="Deal">

       <ScalarProperty Name="DealId" ColumnName="DEAL_ID" />

     </EndProperty>

     <EndProperty Name="DealCost">

       <ScalarProperty Name="DealId" ColumnName="DEAL_ID" />

     </EndProperty>

</AssociationSetMapping>


The configuration of the relationship looks right in the EDMX.

The Storage entity does not have the StoreGeneratedPattern="Identity" tag on the Key property. Should it?

<EntityType Name="DEAL_COST">
<Key>
<PropertyRef Name="DEAL_ID" />
</Key>
<Property Name="DEAL_ID" Type="int64" Nullable="false" />
<Property Name="COST" Type="decimal" />
<Property Name="DEAL_COST_TYPE_ID" Type="int64" />
]]> Wed, 23 Dec 2009 09:45:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5979#5979 ImportEntities can't find related 1..0 or 1 entity : Wethink there’s a problem with... http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5974#5974 Author: davidklitzke
Subject: 1594
Posted: 22-Dec-2009 at 10:44am

We think there’s a problem with the Ids, since the key of DealCost is 0 yet the EM is expecting -100.  We’d recommend that you first check the relationships to ensure they’re actually set up as expected.

]]> Tue, 22 Dec 2009 10:44:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5974#5974 ImportEntities can't find related 1..0 or 1 entity : I have a Deal Entity, it has 1... http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5960#5960 Author: skingaby
Subject: 1594
Posted: 21-Dec-2009 at 8:46am

I have a Deal Entity, it has 1 or more DealPricings and it may or may not have a single DealCost entity depending on Deal.DealType.
We are using a federated persistence context with late instantiation. All of our entities are in a MainPersistenceContext that the grid UI is bound to. However, when we save a row, we spin up a temporarySaveContext, import the row's dirty entities into that temporarySaveContext and then call EntityManager.SaveChangesAsync.

If I add a Deal with a DealPricing, and save, it works fine.
But if I add a Deal with a DealPricing AND a DealCost, the EntityManager.ImportEntities fails:
An entity containing a referenced temporary Id is missing from the list of entities provided. DealCost: -100 was not found.

The entities collection being imported has the following keys:
Deal (-100)
DealPricing (-101)
DealCost (0)

Thanks, Simon.
]]> Mon, 21 Dec 2009 08:46:56 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1594&PID=5960#5960