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

0 vote108 views1 answer
Distinct data types in a table sql query
SQL
1 vote129 views2 answers
Select into temp table
SQL
14 votes118 views2 answers
Sql cast
SQL
2 votes116 views2 answers
Postgres select duplicate columns
SQL
0 vote112 views1 answer
Concatenate columns in table
SQL
2 votes115 views1 answer
Oracle apex list connected users
SQL
1 vote127 views1 answer
Sql server today minus n
SQL
3 votes120 views2 answers
Truncate all tables
SQL
9 votes110 views2 answers
Default number in sql
SQL
1 vote129 views1 answer
Oracle create index if not exists
SQL