Table Inheritance Verify fail

Oct 14, 2011 at 9:15 AM

I design your database base on Table inheritance,  as link

But when verify before generate, it rise error "Column 'PersonTypeID' must be mark unique because there is non-primary key relationship that depend on it".



Oct 18, 2011 at 12:16 AM

Would you please just send your model to me at Also I know you have not generated yet but which DAL are you going to use NHDAL or EFDAL (Entity Framework)? Remember that the source field (or fields) of any relationship much be unique. Usually these are the PK of a table but they need not be. If yo have a type table like PersonType with a PersonTypeId field, it must be the PK of that table or at the very least marked unique.