To get PizzaOrder objects
for a certain room and day, including available Toppings (and PizzaSize) for each
Hibernate HQL: Toppings
available in a lazy way
List<PizzaOrder>
orders =
session.createQuery("from PizzaOrder o
where o.roomNumber = "+ roomNumber +
“ and o.day = " + day ).list();
EDM Entity SQL: Toppings
available by explicit request here:
List<PizzaOrder>
orders = new ObjectQuery<PizzaOrder>("select value o from PizzaEntities.PizzaOrder as o
where o.RoomNumber = " + roomNumber +
“ and
o.Day = " + day, context).
Include("Topping").Include("PizzaSize").ToList();