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 vote197 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
1 vote201 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote216 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote212 views1 answer
Sql server isnull function nor working count
SQL
15 votes194 views2 answers
Select where duplicate mysql
SQL
0 vote185 views2 answers
Default constraint in ms sql
SQL
1 vote195 views2 answers
Regex starts with
SQL
0 vote222 views1 answer
Postgres list users and roles
SQL
0 vote179 views1 answer
View t-sql mail configuration
SQL
0 vote172 views2 answers
Postgresql create role
SQL