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 vote210 views1 answer
Sql ignore
SQL
6 votes245 views1 answer
Postgresql get year
SQL
0 vote189 views1 answer
Call scalar valued function sql
SQL
0 vote179 views1 answer
Output to file mysql
SQL
1 vote212 views1 answer
Mysql change root mysql_native_password
SQL
0 vote238 views1 answer
Renommer schema sql
SQL
18 votes200 views6 answers
Drop table if exists
SQL
8 votes192 views3 answers
Oracle auto_increment
SQL
1 vote203 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes235 views2 answers
Postgres change owner of schema
SQL