title: Dapper select inner join mapping to a model
body: <p>Assume I have the following tables</p>
  <pre><code>  Table Products
    --------
    Id (int)
    Name (varchar)
    BrandId (int)
  
    Table Brands
    -----------
    Id (int)
    BrandName (varchar)
  </code></pre>
  <p>and the following classes in CSharp</p>
  <pre><code>public class Product{
     public int Id { get; set;}
     public string Name { get;}
     public ProductBrand Brand { get;}
  }
  public class ProductBrand{
     public int Id { get; set;}
     public string BrandName { get;}
  }
  </code></pre>
  <p>How can i <code>Select inner join</code> the two tables and map to the <code>ProductBrand</code> model with all its properties in dapper?</p>