One table, multiple entities (Entity framework) Is it possible?

Question

Database

There were 2 tables in the database (storage and storage element). There were many different tables associated with these tables, most of which are the same. I was advised to merge the "Storage" and "Item" tables and just add the "Type" and "Parent Item (Storage)" field. I liked this option, but the following problem arose: in the application I will have to somehow process this data + although these tables have the same fields and related tables, they also have different related tables. I would like to somehow make it so that I have several entities that will refer to one table depending on the type. Is it possible to implement this using Ef?

Answer 1

Yes, in EF it's called Table per Hierarchy (TPH), you can read it here .