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 vote285 views3 answers
Mysql get age from date
SQL
0 vote289 views1 answer
Can sqldatareader be null
SQL
0 vote293 views3 answers
Sql count condition
SQL
1 vote346 views1 answer
Hangfire clear all jobs
SQL
0 vote305 views1 answer
How to search query in python3 sqlite3
SQL
16 votes297 views2 answers
Add column to all tables after first column mysql
SQL
0 vote297 views1 answer
SQL SELECT-Klausel
SQL
-1 vote304 views1 answer
How to dump .csv file into mysql
SQL
3 votes298 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
9 votes305 views6 answers
Replace sql
SQL