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 vote227 views1 answer
Apex ORA-20999
SQL
0 vote234 views1 answer
Date datatype in livesql
SQL
0 vote216 views1 answer
Postgresql isnull with max
SQL
2 votes221 views6 answers
In operator in sql
SQL
0 vote201 views1 answer
Mysql connection with sqlalchecmy
SQL
1 vote213 views2 answers
Postgres copy table from one schema to another
SQL
5 votes207 views1 answer
Migrate sql table another database
SQL
0 vote217 views1 answer
Sql datediff month
SQL
0 vote225 views1 answer
Oracle cpu metric
SQL
0 vote214 views2 answers
Mysql create table if not exists
SQL