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

0 vote374 views1 answer
See the structure of a table mysql
SQL
0 vote337 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
2 votes353 views1 answer
Mysql increment value by 1 in update
SQL
2 votes353 views2 answers
Mamp connect mysql terminal
SQL
-1 vote282 views2 answers
Datetime sql server week
SQL
23 votes333 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote331 views2 answers
Check if word is in column sql
SQL
0 vote349 views1 answer
Copy data from cell to cell mysql
SQL
0 vote324 views1 answer
Update if else mysql
SQL
0 vote350 views1 answer
Multiple replace value mssql
SQL