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};

Similar codes

1 vote189 views1 answer
Oracle truncate partition
SQL
0 vote233 views1 answer
Mysql conf.d exampel
SQL
7 votes257 views2 answers
Create index mysql cli
SQL
0 vote309 views1 answer
Get statis values sql
SQL
0 vote197 views1 answer
Procedure excute monthly oracle
SQL
0 vote263 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote208 views1 answer
Postgress append string in select
SQL
0 vote246 views1 answer
Select true if exists on another table or false sqlserver
SQL
8 votes197 views1 answer
Sql limit results returned
SQL
3 votes198 views1 answer
Postgresql db owner change
SQL