public List<Ingredient> GetFoodIngredientList(string foodName) { FoodManager foodManager = new FoodManager(); Table<DAL.Food> foodTable = foodManager.GetFoodTable(); Table<DAL.IngredientsInFood> ingredientsInFoodTable = GetIngredientsInFoodTable(); Table<DAL.Ingredient> ingredientTable = GetIngredientsTable(); Table<DAL.IngredientDetail> ingredientDetailTable = GetIngredientDetailTable(); var res = (from food in foodTable join ingreInFood in ingredientsInFoodTable on food.foodID equals ingreInFood.foodID join ingre in ingredientTable on ingreInFood.ingredientID equals ingre.ingredientID join ingreDetails in ingredientDetailTable on ingre.ingredientDetailsID equals ingreDetails.ingredientDetailsID where food.name == foodName select new Ingredient { Name = ingreDetails.name, Description = ingreDetails.description, Quantity = ingre.quantity }); return res.ToList(); }