Example: Find all pizza orders for today
(order’s day matches sys_time’s current_day).
No relationship for this, so no connections
in the object graph.
Note no mapped association on day, so no handy
collection of object references to use.
Use a join…
◦EDM Entity SQL: “select value o from PizzaEntities.PizzaOrder as o join
PizzaEntities.SysTime as t on o.Day =
◦EDM LINQ:language-integrated query List<PizzaOrder> l = (from o in
context.PizzaOrder join s in context.SysTime on o.Day equals s.CurrentDay select o).ToList();// no quotes! C# knows query syntax and does type checking
◦HQL: “select o from PizzaOrder o, SysTime t where o.day =