title: Entity Framework and Linq to Entities and .Include() few tables, or maybe
body: <p>i've got a database with a table named PropertyValues where i store every value i need to describe some properties of my database table rows.</p>
  
  <p>For example, table Products which looks like this :</p>
  
  <blockquote>
    <p><strong>ID</strong> <br/>
    <strong>OrderID</strong> //Products table is related with Order table<br>
    <strong>ProductName</strong><br/>
    <strong>ProductType_ID</strong> // ID of PropertyValues table which describes product type (food, parfume, chemicals)<br/> 
    <strong>ProductCountry_ID</strong> <em>// ID of PropertyValues table which links to country where product came from</em>
    <strong>ProductStatusID</strong> <em>//also ID of PropertyValues table which contains product status(availible, not availible)</em><br/></p>
  </blockquote>
  
  <p>with such database model, to get order and all it's products with their type, country and status i'll have to write something like this :</p>
  
  <pre><code>var orders = from o in dbEntities.Order.Include("Products.ProductType")
                                         .Include("Products.ProductCountry")
                                         .Include("Products.ProductStatus")
              select o;
  </code></pre>
  
  <p>and the question is :)<br/>
  can it be done automatically ( so all related entities will be included )<br/>
  or maybe there is better approach ?</p>
  
  <p>Thank You !</p>