title: Manually map column names with class properties
body: <p>I am new to the Dapper micro ORM. So far I am able to use it for simple ORM related stuff but I am not able to map the database column names with the class properties.</p>
  
  <p>For example, I have the following database table:</p>
  
  <pre><code>Table Name: Person
  person_id  int
  first_name varchar(50)
  last_name  varchar(50)
  </code></pre>
  
  <p>and I have a class called Person:</p>
  
  <pre><code>public class Person 
  {
      public int PersonId { get; set; }
      public string FirstName { get; set; }
      public string LastName { get; set; }
  }
  </code></pre>
  
  <p>Please note that my column names in the table are different from the property name of the class to which I am trying to map the data which I got from the query result.</p>
  
  <pre><code>var sql = @"select top 1 PersonId,FirstName,LastName from Person";
  using (var conn = ConnectionFactory.GetConnection())
  {
      var person = conn.Query&lt;Person&gt;(sql).ToList();
      return person;
  }
  </code></pre>
  
  <p>The above code won't work as the column names don't match the object's (Person) properties. In this scenario, is there anything i can do in Dapper to manually map (e.g <code>person_id =&gt; PersonId</code>) the column names with object properties?</p>