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 vote280 views1 answer
Influxdb export to csv
SQL
0 vote278 views1 answer
How to set sql_mode for a query in CI model
SQL
5 votes272 views1 answer
How to get all dates in a month in oracle
SQL
1 vote267 views1 answer
Alphabetical order mysql
SQL
2 votes296 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote261 views1 answer
Postgres where
SQL
0 vote261 views2 answers
T SQl Checking Your Username
SQL
18 votes261 views3 answers
Mysql query add column with default string value
SQL
9 votes273 views2 answers
Convert data type in sql
SQL
0 vote265 views1 answer
Best way to bind parameters to SqlCommand C#
SQL