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 vote284 views1 answer
Character count sql
SQL
0 vote297 views1 answer
Sql change column in existing table
SQL
-1 vote280 views1 answer
Sql add column bit
SQL
1 vote285 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote287 views1 answer
How to combine rows in sql server procedure
SQL
2 votes296 views1 answer
Sql update \
SQL
5 votes294 views2 answers
Postgres update with if condition query
SQL
24 votes270 views5 answers
Sql reset auto increment
SQL
0 vote342 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote315 views1 answer
Sqlite woth cmake
SQL