How to write this query in Linq2Sql

Posted by RememberME on Stack Overflow See other posts from Stack Overflow or by RememberME
Published on 2010-05-10T19:52:40Z Indexed on 2010/05/10 20:24 UTC
Read the original article Hit count: 243

Filed under:
|
|
|
|

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

© Stack Overflow or respective owner

Related posts about linq-to-sql

Related posts about LINQ