title: How to select data from multiple tables with LINQ (entities)
body: <p>I have two tables and corresponding LINQ entities</p>
  
  <ul>
  <li>product</li>
  <li>order</li>
  </ul>
  
  <p>order has a fk_product_id in the database which is linked to pk_product_id in table product</p>
  
  <p>How can I write a method that returns data from both tables, so that I can hook it up to a repeater or gridview?</p>
  
  <p>I found examples where people are writing joins, but I wonder if that's really necessary.</p>