public List <BBeverage> GetAllColdDrinks() { List <BBeverage> beverages = new List <BBeverage>(); BBeverage tempB; BBeverageCategory tempBC; using (SqlConnection connection = new SqlConnection(_connectionString)) { connection.Open(); using (SqlCommand cmd = connection.CreateCommand()) { cmd.CommandText = "select beverage.id as bid, beverage.name as bname, beverage.price as price, beverageCategory.id as id, BeverageCategory.name as name from Beverage, BeverageCategory where Beverage.beverageCategoryID = BeverageCategory.id and BeverageCategory.id = 2"; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tempB = new BBeverage(); tempBC = new BBeverageCategory(); tempB.Id = reader.GetInt32(reader.GetOrdinal("bid")); tempB.Name = reader.GetString(reader.GetOrdinal("bname")); tempB.Price = reader.GetDecimal(reader.GetOrdinal("price")); tempBC.Id = reader.GetInt32(reader.GetOrdinal("id")); tempBC.Name = reader.GetString(reader.GetOrdinal("name")); tempB.BeverageCategory = tempBC; beverages.Add(tempB); } } } return(beverages); }