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 vote187 views2 answers
Mysql allow remote connections
SQL
25 votes210 views4 answers
Sqlserver add column
SQL
1 vote192 views3 answers
Sql select only time from datetime
SQL
2 votes253 views1 answer
Sqlite3 show columns name
SQL
12 votes194 views4 answers
How to take database dump in postgresql
SQL
0 vote204 views1 answer
Get server date mysql
SQL
6 votes299 views2 answers
Database url postgres
SQL
0 vote186 views1 answer
Postgresql find missing id
SQL
-1 vote194 views3 answers
Update mongodb version ubuntu
SQL
1 vote191 views1 answer
Sql where last 12 months
SQL