title: Simple inner join result with Dapper?
body: <p>I can't seem to find documentation or examples for my problem (been searching a while now). I think my problem is pretty straightforward, so here goes.</p>
  
  <p>I have two tables. My primary table is called Persons and the secondary table is PersonEntries. For each person in Person table, i can have 0 or more entries in the PersonEntries table. Like this.</p>
  
  <pre><code>Table: Person
  Id
  Name
  
  Table: PersonEntry
  PersonId
  CheckinTime
  CheckoutTime
  </code></pre>
  
  <p>I have two objects like this</p>
  
  <pre><code>public class Person {
    public string Name;
    public List&lt;PersonEntry&gt; PersonEntries;
  }
  
  public class PersonEntry {
    public DateTime CheckinTime;
    public DateTime CheckoutTime;
  }
  </code></pre>
  
  <p>If i was to get it from the database into my c# classes how would i do it? I can map a single table into my c# class and do it for each table, but then i'm left to match what entries maps to what person.</p>
  
  <p>I've seen several examples of mapping ONE PersonEntry to ONE Person, the problem here is that i have a zero-to-many relation. My Person have a <strong>LIST</strong> of PersonEntry items.</p>