In the project I'm working on, I have the following questions:
First, I made some inheritance tables in the database where each one has only one column, the id (which is pk and fk of the table to which they inherit), and when generating the model (edmx) from the database data tables that have only one column are not created, is there any configuration where I can configure this? I've already searched and found nothing related.
Secondly I would like to know if when the model is generated there is also some configuration where you can choose the tables that will be inherited to be generated with the correct configuration, otherwise I have to make the inheritance every time. Which makes the process costly.
NOTE: I use EF6.
Sample template similar to the one I'm using:
Homologation (Entity): id, situation, category, telephone, addresses
Homologacao_curso (Entidade com Herança): id (is primary key and foreing key referencing the approval entity) id_curso (fk of the course entity)
homologation_capacitadora (Entity with Inheritance): id (is primary key and foreing key referencing the approval entity)
1st Problem: When generating the edmx the only entities generated are homologation and homologacao_curso. As the authorizationor_enabling entity does not need another data except the id it is not generated.