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 vote217 views2 answers
Truncate table sqlite
SQL
0 vote173 views1 answer
Into operator in sql
SQL
50 votes222 views4 answers
Sql alter type of column
SQL
1 vote155 views1 answer
Mysql count multiple columns in one query
SQL
3 votes176 views2 answers
Search text in all sql server stored procedure
SQL
6 votes138 views1 answer
Phpmyadmin reset root password
SQL
0 vote218 views1 answer
How to get number of months between 2 dates sql server
SQL
8 votes141 views1 answer
Unique vs primary key
SQL
0 vote149 views1 answer
Enable full text search mysql
SQL
1 vote137 views1 answer
Mysql batch insert
SQL