Table Per Type (TPT) Inheritance Insert Data Via EDM Framework

Introduction

Today, in this article let's play around with an interesting and very useful concept in Entity Framework.

Question: What is Table per Type Inheritance?

In simple terms "The parent entity is associated with many child entities where the child entities can inherit the data from the parent. Here the primary key of the parent entity is shared with the child entity that maintains a 1-1 relationship".

Step 1: Create a new web application

Step 2: Entities in the DB looks like this:

Step 3: Adding New Entity Data Model Framework

Step 4: Select the tables from the DB

Step 5: Entity in Model Browser

Step 6: Delete association links between entities

Step 7: Select the base types

Step 8: New inheritance associations established

Step 10: Delete the child table or entities Ids that will inherit from the parent entity

Step 11: The complete code of WebForm1.aspx looks like this: