title: ADO.Net EF - how to define foreign key relation in model first approach?
body: <p>I have been having previous issues regards to class inheritance and structuring a database around this and using the entity framework to no success. So I have tried to create the entities inside visual studio and see what database tables it creates automatically. </p>
  
  <p>I have a Entity MediaItem which is Abstract and Game Inherits from this. Game has a Console (Int) which corresponds to ConsoleID. However, when I generate the database I get an extra unwanted column (ConsoleTypes_ConsoleID) inside MediaItems_Game table. Why is this and how can I prevent this from happening? Thanks.</p>
  
  <p><img src="https://i.stack.imgur.com/aMauF.jpg" alt="enter image description here"></p>