i've got this tables in my database.
With Entity Framework i would like to have something like that:
I've used table-per-hierarchy inheritance, so i added a new entity for the premium user and map it to the user entity with conditions to IsPremiumUser property. I would like to have the PremiumAccount table associate to the PremiumUser entity, but it won't work like i did it :-/ I've got this error message:
Error 3021: Problem in Mapping Fragment starting at line 113: Each of the following columns in table PremiumAccount is mapped to multiple conceptual side properties: PremiumAccount.UserID is mapped to
Is there any solution to my problem? Can I associate the PremiumAccount entity to an inherited entity? Is there another way to do this?