title: Subsonic 3 - SimpleRepository
body: <p>I am playing around with Subsonic 3's simple repository and am hitting walls in understanding how to deal with foreign keys...</p>
  
  <p>If I have a product object containing</p>
  
  <pre><code>int ID; 
  
  string name; 
  
  string description; 
  
  Category category; 
  
  int categoryID (this one is just to persist the product's categoryID to the DB)
  
  and a category object containing 
  
  int ID; 
  
  string name;
  </code></pre>
  
  <p>How can I use the repository to bring back a list of all products with their category object instantiated?</p>
  
  <p>At the moment I have written a linq query which joins on product.categoryID = category.ID which is all well and good, but when I .ToList() the results of this query, the product's Category isn't instantiated.</p>
  
  <p>Is there a way to do this, or do I have to manually instantiate the Category for each product?</p>
  
  <p>Thanks,</p>
  
  <p>Paul</p>