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

2 votes176 views1 answer
Enum in SQL Server
SQL
5 votes174 views1 answer
How to check nls timestamp format in oracle
SQL
5 votes172 views1 answer
Postgres integer to serial
SQL
4 votes176 views2 answers
REST API
SQL
0 vote170 views1 answer
Get records in sql according to month name and count
SQL
0 vote192 views1 answer
Select 1 from orders
SQL
8 votes178 views1 answer
How to remove tables from postgresql
SQL
8 votes205 views1 answer
Mysql dump restore
SQL
1 vote179 views1 answer
Oracle extract minute from date
SQL
0 vote185 views1 answer
How to insert a uniqueidentifier in sql
SQL