Trying my hand at TPH inheritance and having an annoying little issue. Here's the approach:
1) Start with table "Skill" with column (nvarchar) "SkillCode"
2) Add entity "BusinessSkill", set to inherit from Skill
3) Map to BusinessSkill to Skill table
4) add condition BusinessSkill of SkillCode = "business"
Here I tried to build and got error:
Error 1 Error 3032: Problem in Mapping Fragment starting at line 1429: Condition member 'Skill.SkillCode' with a condition other than 'IsNull=False' is mapped. Either remove the condition on Skill.SkillCode or remove it from the mapping.
C:\Projects\TAP\TAP.Core\TAPModel.edmx 1430 15 TAP.Core
After reading up I found a suggestion to delete SkillCode from Skill, that resulted in this error:
Error 1 Error 3034: Problem in Mapping Fragments starting at lines 1429, 1436: Two entities with different keys are mapped to the same row. Ensure these two mapping fragments do not map two groups of entities with overlapping keys to the same group of rows.
C:\Projects\TAP\TAP.Core\TAPModel.edmx 1430 15 TAP.Core
View Complete Post