title: Understanding EF under the hood. Include vs Joins
body: <p>I am working with Entity Framework for a while but still have some "black holes" with how it is working under the hood. Even after reading couple of articles I'm not sure that my understanding is correct.</p>
  
  <hr>
  
  <p>Lets start with questions:</p>
  
  <ul>
  <li>How EF Include is working under the hood?</li>
  <li>What are the differences between Join and Include?</li>
  <li>Performance issues with Include (lazy loading vs eager loading, generated SQL queries, etc.)?</li>
  <li>When I should use Join instead Include and vice versa?</li>
  </ul>