title: bottleneck using entity framework inheritance
body: <p>so first my entities</p>
  
  <p><img src="https://i.stack.imgur.com/vs4if.png" alt="Entities"></p>
  
  <p>the problem i want to have a page with all the story titles and their types</p>
  
  <p>there are three stories <code>LongStory</code> , <code>CoOpStory</code>, <code>GenericStory</code></p>
  
  <p>the generic story is associated with <code>StoryType</code> for the type of the generic story</p>
  
  <p>i have two problems </p>
  
  <p>first when i want to check if the story is <code>LongStory</code> or <code>CoOpStory</code> i have to get all the entity and check the entity type if it is <code>LongStory</code> then do something , i don't know how to retrieve some data [only the title] and check the type </p>
  
  <p>my second problem like i said i want to have a page with all the story titles and their types i don't know how to do that without making a lot of queries , i can't make a join to the <code>StoryType</code> table because it must be <code>GenericStory</code> to be associated with that , so what i do first get all the stories then do an extra query for every <code>GenericStory</code> to get the type</p>