title: EF - AND NOT EXISTS (SELECT 1 ...) with Entity Framework
body: <p>I am trying to run this query using Entity Framework in my ASP.NET MVC project but I am not succeeding. Could anyone help me do this using LINQ?</p>
  
  <pre><code>SELECT p.*
  FROM Produtos p
  WHERE p.enterpriseID = '00000000000191' and p.productId &lt;&gt; '14' 
  AND NOT EXISTS (SELECT 1 FROM SimilarProducts sp WHERE sp.similarId = 
  p.productId)
  </code></pre>
  
  <p>TABLES:</p>
  
  <pre><code>PRODUCT                        SIMILARPRODUCTS
  productId|enterpriseId         id|productId|similarId
  </code></pre>