IDbConnection (ExecuteMethods for Person)

IDbConnectionExecuteQueryPerson.cs

// Query
using (var connection = new SqlConnection(connectionString))
{
     connection.ExecuteQuery<Person>("SELECT * FROM [Person] WHERE Id = @Id;", new { Id = 10045 });
}

// Insert
using (var connection = new SqlConnection(connectionString))
{
     var entity = new
     {
          Id = 10045,
          FirstName = "John",
          LastName = "Smith",
          LastUpdatedUtc = DateTime.UtcNow
     };
     var affectedRows = connection.ExecuteNonQuery("INSERT INTO [Person] (Id, FirstName, LastName, LastUpdatedUtc, CreatedDateUtc) " +
          "VALUES (@Id, @FirstName, @LastName, @LastUpdatedUtc, GETUTCDATE());", entity);
}

// Update
using (var connection = new SqlConnection(connectionString))
{
     var entity = new
     {
          Id = 10045,
          FirstName = "John",
          LastName = "Smith",
          LastUpdatedUtc = DateTime.UtcNow
     };
     var affectedRows = connection.ExecuteNonQuery("UPDATE [Person] SET FirstName = @FirstName, LastName = @LastName, LastUpdatedUtc = @LastUpdatedUtc " +
          "WHERE Id = @Id;", entity);
}

// Delete
using (var connection = new SqlConnection(connectionString))
{
     var affectedRows = connection.ExecuteNonQuery("DELETE FROM [Person] WHERE Id = @Id;", new { Id = 10045 });
}