title: Sql Not In in Linq Issue
body: <p>I have this sql query. I can convert most of the query to linq but I don't understand how to implement the "not in" portion in this particular query. Here is my query:</p>
  
  <pre><code>SELECT d.processid,d.name,t.test_name
  FROM dc_tp_tprocess d
  left outer join dc_tp_tprocedured pd on pd.processid=d.processid
  left outer join dc_tp_test t on t.procedureid=pd.procedureid
  where d.active='Y' and t.testid=1 
                     and d.processid not in (1,2,6,8,9,10)
  order by t.testid,d.processid
  </code></pre>