public List <Address> GetShippingAdressByUserId(int userId) { var addressesShipping = new List <AddressDAL>(); using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); SqlCommand cmd = new SqlCommand("PS_GetShippingAddrsesByUserId", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@UserId", userId)); using (SqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { var addressShipping = new AddressDAL(); addressShipping.AddressId = (int)rdr["ShippingAddressId"]; addressShipping.Number = (int)rdr["Number"]; addressShipping.Street = (string)rdr["Street"]; addressShipping.ZipCode = (int)rdr["ZipCode"]; addressShipping.City = (string)rdr["City"]; addressShipping.Country = (string)rdr["Country"]; addressShipping.IsDefault = (bool)rdr["IsDefault"]; addressesShipping.Add(addressShipping); } } } List <Address> userAddressShipping = addressesShipping.Select(addressShipping => addressShipping.ToDomain()).ToList(); return(userAddressShipping); }