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 vote249 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote369 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote318 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote285 views1 answer
Oracle list chain steps
SQL
5 votes355 views2 answers
How to ascending order in sql
SQL
0 vote300 views1 answer
Get records in sql according to month name and count
SQL
57 votes532 views5 answers
How to create a new user in postgresql
SQL
9 votes302 views2 answers
Sql limit order by
SQL
0 vote314 views1 answer
How to add timestamp column in mysql
SQL
0 vote301 views2 answers
How to type a blank discord messgae
SQL