Entity Framework - Entity Provider Level. First Experiment with Inheritance

posted by  hjwin (10)  11 months ago (mtaulty.com)

In order to look at the next keywords that I wanted to look at (IS OF, OFTYPE, TREAT) I need to introduce some kind of inheritance. I modified my Shippers table in Northwind to try and model inheritance using the table-per-hierarchy model (it's not the only way that you can model inheritance in EF) where you store all the "objects" into a single table and have some discriminating column so that you can tell them apart.

I modified the Shippers table so it now has 2 extra columns on it;

alter table shippers    add ShipperType int