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

37 votes272 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote262 views1 answer
What is the difference between now() and current_date()?
SQL
2 votes261 views1 answer
Oracle calculated column
SQL
0 vote264 views1 answer
Clear query cache sql server
SQL
2 votes236 views2 answers
Select multiple tables mysql
SQL
4 votes290 views3 answers
Mysql get column names from table
SQL
0 vote288 views2 answers
Mysql insert into multiple tables
SQL
6 votes278 views3 answers
Create database mysql utf8
SQL
2 votes243 views1 answer
Mysql list users on ubuntu
SQL
0 vote288 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL