There are several ways to establish inheritance between entities in a model, but the easiest is just to specify the base class in the Properties Window. You do need to remember to delete the unnecessary relationships and properties, though. Otherwise, the Entity Model Designer gets its little self confused.
Put On Your Thinking Hat
Give it a try!
Add a new model to your project and use the wizard to add the three “TPT” tables to it.
Using the Properties Window set the base type of TPTBakedGood
to TPIngredient
.
Delete the unnecessary properties and the original association between TPTBakedGood
and TPTIngredient
.