sub query in linq
var result = from ord in db.Orders
join osub in (from o in db.Orders
where o.region = "Canada"
select o)
on ord.orderId equals osub.orderId
select new {ord.custId, ord.orderDate};