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

0 vote130 views1 answer
Prepared statement mysql java delete selected rows
SQL
6 votes135 views4 answers
Eloquent to sql with bindings
SQL
0 vote140 views1 answer
Check index sql server
SQL
7 votes148 views4 answers
How to reset the identity column in sql server
SQL
1 vote154 views2 answers
Oracle create synonym
SQL
0 vote142 views1 answer
Sql server check whether column has same equal values
SQL
0 vote163 views1 answer
Sql get year from datetime field
SQL
25 votes239 views6 answers
Change column name mysql
SQL
0 vote145 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
37 votes193 views6 answers
Mysql update
SQL