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

3 votes218 views2 answers
Search text in all sql server stored procedure
SQL
0 vote290 views1 answer
Sql alchemy escape ; in insert statement
SQL
1 vote186 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote196 views1 answer
Mysql get nth highest
SQL
6 votes180 views2 answers
If not exists insert sql
SQL
1 vote214 views1 answer
Nvl postgres
SQL
42 votes274 views6 answers
Rename table sql server
SQL
0 vote185 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote181 views1 answer
Dns slave zone convert
SQL
0 vote159 views1 answer
QCompleter con sql
SQL