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

9 votes138 views3 answers
Oracle undo usage by session
SQL
1 vote164 views1 answer
Sql server if exists update else insert
SQL
3 votes134 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote136 views1 answer
What is the use of index in mysql table
SQL
2 votes137 views1 answer
Oracle virtual column
SQL
2 votes135 views1 answer
Oracle find constraints referencing a table
SQL
4 votes173 views6 answers
Select sql
SQL
8 votes131 views3 answers
Duplicate entry
SQL
0 vote140 views1 answer
Mysql terminal list table
SQL
0 vote132 views1 answer
Mysql start of today
SQL