Hello, I am very new to Entity Framework and am wondering about the basic concept of Table Per Type Inheritance and how the entity relates to other tables.
In the physical database the relation works like the following...
Person (Person ID PK)
Customer (Customer ID PK, Person ID FK)
Order (Order ID PK, Customer ID)
My question is before I created the Inheritance the relationship between Customer and Orders would relate back to Patient using the Patient ID, after the inheritance it now looks for a Person ID which is not in the Column drop down list. Why is taking place because even with the inheritance I should still be able to use the Patient ID or is this not a situation where I should be using inheritance?