title: Lambda not in like SQL
body: <p>I’m working with MVC 5 and I’m quite new on it. How can  convert the below sql code to lambda expression. Basically what I’m trying to do is to show all records that ProductID not exist in Scrap Table</p>
  
  <pre><code>Select * from Product
   where ProductID not in (Select ProductID from Scrap where ref = '123')
   and active = 1
  </code></pre>