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); }