Inheritance is a property of Object-Oriented Programming which enables you to extend new classes from existing ones and provide additional functionality to them. Entity Framework supports the following types of inheritance:
Table per hierarchy
Table per type
Table per concrete type
To implement Table per Hierarchy, or Single Table Inheritance, simply inherit a new class from your existing entity class and add the properties you need. As an example, suppose we need to create an entity called OldEmployee
from the Employee entity in our Payroll EDM. To do this, create a new entity called OldEmployee
in the designer and specify the base type as Employee. Here is how the two entities are represented in the EDM:
<EntityType Name="Employee"> <Key> <PropertyRef Name="EmployeeID" /> </Key> <Property Name="EmployeeID" Type="Int32" Nullable="false" /> <Property Name="FirstName" Type="String" Nullable="false" MaxLength...