IDbConnection (Query<Person>)

IDbConnectionQueryPerson.cs

// Query
using (var connection = new SqlConnection(connectionString))
{
     var person = connection.Query<Person>(p => p.Id == 10045).First();
}

// Insert
using (var connection = new SqlConnection(connectionString))
{
     var person = new Person
     {
          FirstName = "John",
          LastName = "Smith",
          LastUpdatedUtc = DateTime.UtcNow,
          CreatedDateUtc = DateTime.UtcNow
     };
     var personId = connection.Insert(person);
}

// Update
using (var connection = new SqlConnection(connectionString))
{
     var person = connection.Query<Person>(p => p.Id == 10045).First();
     person.FirstName = "John (Updated)";
     person.LastName = "Smith (Updated)";
     person.LastUpdatedUtc = DateTime.UtcNow;
     var updatedRows = connection.Update(person);
}

// Delete
using (var connection = new SqlConnection(connectionString))
{
     var deletedRows = connection.Delete<Person>(p => p.Id == 10045);
}