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

6 votes275 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote261 views1 answer
How to update random rows in sql
SQL
0 vote266 views1 answer
Redirection 301 htaccess nom de domaine
SQL
6 votes236 views2 answers
Spring data jpa application.properties mysql
SQL
4 votes265 views3 answers
Count with where
SQL
0 vote267 views2 answers
SQL Server Standard
SQL
1 vote279 views1 answer
Postgres check for foreign key
SQL
0 vote283 views1 answer
My sql data file extention
SQL
3 votes277 views1 answer
Pl sql escape &
SQL
4 votes351 views2 answers
Delete all table oracle
SQL