title: how to use Linq " NOT IN"
body: <p>I'm using Entity Framework<br>
  So I want to write a sql command using two tables - tblContractor and tbSiteByCont tables.
  It looks like this in SQL</p>
  
  <pre><code>SELECT     PKConID, Fname, Lname
  FROM         tblContractor
  WHERE     (PKConID NOT IN
                            (SELECT     FKConID
                              FROM          tbSiteByCont
                              WHERE      (FKSiteID = 13)))
  </code></pre>
  
  <p>but I don't know how to write in Linq.</p>
  
  <p>I tried like this</p>
  
  <pre><code>  var query1 = from s in db.tblSiteByConts   
                          where  s.FKSiteID == id
                          select s.FKConID;
  
  
              var query = from c in db.tblContractors   
                          where c.PKConID != query1.Any()
                          select Contractor;
  </code></pre>
  
  <p>But this doesn't work.
  So how should I write it? What is the procedure? I'm new to Linq.</p>