title: Entity Framework model and foreign key property
body: <p>I have 2 tables that I import to EF model.<br>
  First table has a property [section] that acts as foreign key to the second table. 
  When I map this property in model to the table and try to compile I get this error:</p>
  
  <blockquote>
    <p>Problem in Mapping Fragments starting
    at lines 158, 174: Non-Primary-Key
    column(s) [Section] are being mapped
    in both fragments to different
    conceptual side properties - data
    inconsistency is possible because the
    corresponding conceptual side
    properties can be independently
    modified.</p>
  </blockquote>
  
  <p>If i remove this property from the model it passes, but when I query the data I don't have the section field.</p>
  
  <p>I know that I can get it by using the navigation field and reading this property from the second table, but to make it work I must include the other table in my query.</p>
  
  <pre><code>var res  = from name in Context.Table1.Include("Table2")...
  </code></pre>
  
  <p>Why do I need to include the association just for one field? </p>
  
  <p><strong>UPDATE</strong><br>
  To make it more clear:</p>
  
  <p><em>Table 1 has fields:</em><br>
  ItemId - key<br>
  section - foreign  key<br>
  title  </p>
  
  <p><em>Table 2 has fields:</em><br>
  SectionId - key<br>
  Name</p>
  
  <p>When I set the associations the section property from the first table must be removed. </p>