public override IReadOnlyList <Address> Translate(SqlCommand command, IDataRowReader reader)
        {
            var addresses = new List <Address>();

            while (reader.Read())
            {
                addresses.Add(new Address(
                                  reader.GetInt32("PersonId"),
                                  (AddressType)reader.GetByte("AddressTypeId"),
                                  reader.GetString("Line1"),
                                  reader.GetString("Line2"),
                                  reader.GetString("City"),
                                  reader.GetString("StateCode"),
                                  reader.GetString("ZipCode")));
            }

            return(addresses);
        }