Last post May 20, 2009 09:53 AM by cgeers
Apr 24, 2009 05:14 AM|jumpingmattflash|LINK
May 20, 2009 09:53 AM|cgeers|LINK
Setup your database structure as follows:
Put a foreign key on the [Person] table pointing to the [PersonType] table (Person.PersonTypeId -> PersonType.PersonTypeId). You should link a person to a type using the primary key value of the PersonType table, not the value of the name of the type.
Next add a new Entity Data Model to your solution and have it generate a model from this database. Just select those two tables to include in the model.
If you are having trouble with this, please send me a private message and I'll whip up an example.