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 vote126 views1 answer
ORA-13717
SQL
0 vote159 views1 answer
Reset a table's identity column and remove test records
SQL
14 votes134 views1 answer
Oracle alter table add column not null
SQL
10 votes128 views2 answers
Sql pagination offset
SQL
2 votes114 views2 answers
Oracle create table if not exists
SQL
0 vote121 views1 answer
Mysql convert charset
SQL
13 votes122 views4 answers
Mysql get last row
SQL
4 votes120 views1 answer
Delete record mysql query
SQL
3 votes131 views1 answer
Sql cast to integer
SQL
0 vote138 views1 answer
Codigo crear tablas sql server
SQL