title: Inheritance in entity framework - Table per concrete class?
body: <p>I have an existing database containing an article and a blog table. These have common columns such as title, author repeated in the two tables. I want to utilise entity framework to create a Content entity that pulls in the common properties so i can inherit the Content entity in the Article and Blog entity. </p>
  
  <p>The idea being that I can say ok just get me all the content on the site in the last 10 days, i dont care whether its a blog or article. Then when i need to actually fetch an article ill go get the specific entity. </p>
  
  <p>I have set up a content entity base and pulled in all the common blog and goal properties. Problem is what im trying to say in Contents. Ive got TWO mappings one to blog table  and one to article table and EF complains that it cant work out which one to goto. I was hoping to add conditions to do this but if i add a blog specific condition (thats not listed in my base class) it complains it cant find the mapping. </p>
  
  <p>I spose my first question is am I looking at this totally backwards in order to make my Contents entity get data from article table and blog table?</p>
  
  <p>Thanks </p>
  
  <p>Phil</p>
  
  <p>Edit : Adding model and db schemas</p>
  
  <p><img src="https://i52.photobucket.com/albums/g34/Pheedbak/Capture-1.gif" alt="alt text">
  <img src="https://i52.photobucket.com/albums/g34/Pheedbak/Capture.gif" alt="alt text"></p>