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 vote99 views1 answer
Search In the Database using Text
SQL
1 vote116 views1 answer
Set autoincrement to 0
SQL
0 vote118 views1 answer
Less mysql display
SQL
5 votes110 views3 answers
Sql make column nullable
SQL
0 vote126 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote116 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote109 views3 answers
Between keyword sql
SQL
0 vote97 views1 answer
Get who is hired in month in sql
SQL
1 vote114 views1 answer
Oracle grant on all tables in schema
SQL
28 votes108 views4 answers
Delete database mysql
SQL