title: How to make a query that returns a dictionary with values from two joined tables in Servicestack.Ormlite?
body: <p>I've got two tables, Card and User. Card has a reference to user, so that a user can have many cards, but a card can only have one user.
  I have made this mysql-query that returns the Card.Id and User.LastName:</p>
  
  <pre><code>SELECT Card.Id,User.LastName FROM Card
      left join User on Card.UserId = User.Id
      where Card.Id = '1';
  </code></pre>
  
  <p>How can I make that query with servicestack ormlite?
  I've tried something like this:</p>
  
  <pre><code>var cardIdAndUserName = db.Dictionary&lt;int, string&gt;(db.From&lt;Card&gt;()
      .LeftJoin&lt;Card, User&gt;((c,u) =&gt; c.UserId == u.Id)
      .Select(card =&gt; new {card.id, user.Lastname}));
  </code></pre>
  
  <p>I could not get the code above to work because the .Select statement will only let me get columns from the Card table. I guess I could make a db.Select(InfoINeedObject) intead of the db.dictionary call, but then I have to create a new class, InfoINeedObject.</p>