EntityFramework mapping issue RSS

• • Reply
  

  wsyeager36

  Member

  385 Points

  458 Posts

  EntityFramework mapping issue

  Feb 18, 2013 01:57 PM|LINK

  I desperately need some help here...

  Error 4 Error 3003: Problem in mapping fragments starting at line 814:All the key properties (Users.UserNumber) of the EntitySet Users must be mapped to all the key properties (UsersGroupsLK.GroupNumber, UsersGroupsLK.UserNumber) of table UsersGroupsLK. C:\Projects\NPP\NPP\NPP\EFModels\CMS\CMSEFModel\CMSModel.edmx 815 15 CMSEFModel

  I have a parent entity Users whose primary key is UserNumber.

  The child entity is UserGroupsLK whose composite primary key is UserNumber & GroupNumber.

  In order to flatten data and display in a View, I need the GroupNumber from the child entity on the Parent entity, so I copied the GroupNumber in the designer from the child entity and pasted it to the parent entity and added a mapping to the UsersGroupsLK entity via the designer

  Now, when trying to compile, I get the error.

  Here is the XML in the designer where the error is (starting at:

  <EntityTypeMapping TypeName="IsTypeOf(wmswebModel.User)">

  <EntitySetMapping Name="Users"><EntityTypeMapping TypeName="wmswebModel.User"><MappingFragment StoreEntitySet="Users">
   <ScalarProperty Name="UserNumber" ColumnName="UserNumber" />
   <ScalarProperty Name="UserID" ColumnName="UserID" />
   <ScalarProperty Name="UserName" ColumnName="UserName" />
   <ScalarProperty Name="UserEmail" ColumnName="UserEmail" />
   <ScalarProperty Name="UserPassword" ColumnName="UserPassword" />
   <ScalarProperty Name="MustChangePassword" ColumnName="MustChangePassword" />
   <ScalarProperty Name="ActiveFlag" ColumnName="ActiveFlag" />
   <ScalarProperty Name="DateAdded" ColumnName="DateAdded" />
   <ScalarProperty Name="AddedBy" ColumnName="AddedBy" />
   <ScalarProperty Name="LastUpdated" ColumnName="LastUpdated" />
   <ScalarProperty Name="LastUpdatedBy" ColumnName="LastUpdatedBy" />
   </MappingFragment></EntityTypeMapping>
   <EntityTypeMapping TypeName="IsTypeOf(wmswebModel.User)">
   <MappingFragment StoreEntitySet="UsersGroupsLK">
   <ScalarProperty Name="GroupName" ColumnName="GroupName" />
   <ScalarProperty Name="LastUpdatedBy" ColumnName="LastUpdatedBy" />
   <ScalarProperty Name="LastUpdated" ColumnName="LastUpdated" />
   <ScalarProperty Name="AddedBy" ColumnName="AddedBy" />
   <ScalarProperty Name="DateAdded" ColumnName="DateAdded" />
   <ScalarProperty Name="ActiveFlag" ColumnName="ActiveFlag" />
   <ScalarProperty Name="UserID" ColumnName="UserID" />
   <ScalarProperty Name="GroupNumber" ColumnName="GroupNumber" />
   <ScalarProperty Name="UserNumber" ColumnName="UserNumber" />
   </MappingFragment>
   </EntityTypeMapping></EntitySetMapping>
   <EntitySetMapping Name="UsersGroupsLKs"><EntityTypeMapping TypeName="wmswebModel.UsersGroupsLK"><MappingFragment StoreEntitySet="UsersGroupsLK">
   <ScalarProperty Name="UserNumber" ColumnName="UserNumber" />
   <ScalarProperty Name="GroupNumber" ColumnName="GroupNumber" />
   <ScalarProperty Name="UserID" ColumnName="UserID" />
   <ScalarProperty Name="GroupName" ColumnName="GroupName" />
   <ScalarProperty Name="ActiveFlag" ColumnName="ActiveFlag" />
   <ScalarProperty Name="DateAdded" ColumnName="DateAdded" />
   <ScalarProperty Name="AddedBy" ColumnName="AddedBy" />
   <ScalarProperty Name="LastUpdated" ColumnName="LastUpdated" />
   <ScalarProperty Name="LastUpdatedBy" ColumnName="LastUpdatedBy" />
   </MappingFragment></EntityTypeMapping></EntitySetMapping>

  Thanks,
  
  Bill Yeager
  MCP.Net, BCIP
  • Edited by wsyeager36 on Feb 18, 2013 02:09 PM
• • Reply
  

  Mark - MSFT

  Contributor

  7071 Points

  435 Posts

  Microsoft

  Re: EntityFramework mapping issue

  Feb 26, 2013 01:17 AM|LINK

  Hi wsyeager,

  Seems your same thread has right direction:

  http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/c1ce8946-9e44-466d-ae47-e3ba16c7a188

  Best Regards

  Please mark the replies as answers if they help or unmark if not.
  If you have any feedback about my replies, please contact msdnmg@microsoft.com
  Microsoft One Code Framework
  • Marked as answer by Mark - MSFT on Mar 01, 2013 12:20 AM