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

6 votes174 views3 answers
Update with inner join postgres
SQL
14 votes181 views4 answers
Import database through command line
SQL
2 votes175 views1 answer
Convert series number to date in sql
SQL
0 vote178 views1 answer
Sql common columns
SQL
1 vote190 views1 answer
Events mysql
SQL
0 vote175 views1 answer
If null don't update
SQL
6 votes2.1K views1 answer
Sql select second max
SQL
0 vote176 views1 answer
Sum values by month mariadb
SQL
2 votes183 views2 answers
Sql percentage
SQL
4 votes191 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL