title: Can petapoco handle joins and query generated columns?
body: <p>I have this object called Event, and event has some other linked tables.</p>
  
  <pre><code>[PetaPoco.ResultColumn]
  public Models.User Presenter { get; set; }
  </code></pre>
  
  <p>Petapoco does a wonderful job by fetching my objects when I use:</p>
  
  <pre><code>evt = db.Fetch&lt;Models.Event, Models.User&gt;(";EXEC GetEventDetails @id", new { id = id });
  </code></pre>
  
  <p>This brings me the event, with the presenter data.</p>
  
  <p>But the problem is that I also have a column being generated in my query 'Available seats'
  This column is linked to the object as:</p>
  
  <pre><code>[PetaPoco.ResultColumn]
  public string AvailableSeats { get; set; }
  </code></pre>
  
  <p>The problem is: when I use the db.Fetch, Available seats is null.
  My solution now is:</p>
  
  <pre><code>evt = db.Fetch&lt;Models.Event&gt;(";EXEC GetEventDetails @id", new { id = id })[0];
  evt.Presenter = db.FirstOrDefault&lt;Models.User&gt;("WHERE id=" + evt.PresenterId);
  </code></pre>
  
  <p>but I don't really like this. it should be all in one line of code.</p>
  
  <p>Is this a petapoco bug, or am I doing something wrong there?</p>