New Posts New Posts RSS Feed: ImportEntities can't find related 1..0 or 1 entity
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

ImportEntities can't find related 1..0 or 1 entity
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post Topic: ImportEntities can't find related 1..0 or 1 entity
    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?

 
Back to Top
skingaby View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 23-Apr-2008
Location: United States
Posts: 146 		Post Options Post Options   Quote skingaby Quote  Post ReplyReply Direct Link To This Post 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" />
Back to Top
davidklitzke View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 14-Jun-2007
Posts: 715 		Post Options Post Options   Quote davidklitzke Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
skingaby View Drop Down
DevForce MVP
DevForce MVP
Avatar

Joined: 23-Apr-2008
Location: United States
Posts: 146 		Post Options Post Options   Quote skingaby Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down