public void Delete(int id)
{
using (var connection = BolfTrackerDbConnection.GetProfiledConnection())
{
connection.Open();
connection.Execute("DELETE FROM Shot WHERE Id = @Id", new { Id = id });
}
}