sub query in linq

Solutions on MaxInterview for sub query in linq by the best coders in the world

showing results for - "sub query in linq"
Lya
14 Jul 2017
1var result = from ord in db.Orders
2             join osub in (from o in db.Orders
3		            where o.region = "Canada"
4		            select o)
5                on ord.orderId equals osub.orderId 
6	      select new {ord.custId, ord.orderDate};