How to split a data table v2?
I wrote a post which explains how to split a data table.
But there is a bug in EF and so I couldn't add a new Category with this EDM. Colin wrote about this bug here.
So, in my last EDM, I just have to reverse the Principal and the Dependant roles of my association:
<Association Name="CategoryCategoryPicture">
<End Type="NorthwindModel.Category" Role="Category" Multiplicity="1" />
<End Type="NorthwindModel.CategoryPicture" Role="CategoryPicture" Multiplicity="1" />
<ReferentialConstraint>
<Principal Role="CategoryPicture">
<PropertyRef Name="CategoryID" />
</Principal>
<Dependent Role="Category">
<PropertyRef Name="CategoryID" />
</Dependent>
</ReferentialConstraint>
</Association>