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 votes64 views1 answer
Sql group by different columns
SQL
0 vote87 views1 answer
Mariadb set vertical output format
SQL
0 vote109 views1 answer
Db format in quotation
SQL
0 vote98 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote90 views1 answer
How to execute stored output to csv files
SQL
0 vote108 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
3 votes94 views2 answers
Postgres download
SQL
50 votes197 views6 answers
Install mysql on ubuntu
SQL
0 vote101 views1 answer
Acual month sql
SQL
4 votes98 views1 answer
Create db table
SQL