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 vote213 views2 answers
Install sql server management studio ubuntu
SQL
0 vote179 views1 answer
Mysql grant user wildcard database
SQL
1 vote219 views1 answer
How not to sort by average rating
SQL
1 vote170 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote127 views1 answer
Finish transaction sql
SQL
1 vote189 views1 answer
Where not in array sql
SQL
-2 votes194 views2 answers
Union all in sql
SQL
1 vote176 views1 answer
SQL: merging multiple row data in string
SQL
5 votes210 views3 answers
Sql limit offset
SQL
4 votes168 views1 answer
Change nls_date_format
SQL