How to write this query in Linq2Sql
- by RememberME
I have a table company which holds the company_id, company_name and other details.
I have a table subcontracts which has a company_id column that maps to company.company_id.
How can I write a select statement to get all companies which have not been assigned to a subcontract? IE The company_id cannot be found in subcontracts.company_id