title: Translating SQL to lambda expression
body: <p>How can I translate this to a lambda expression? Can anyone please help?     </p>
  
  <pre><code>SELECT 
      p.*
  FROM
      db.MainProduct p 
  WHERE
      p.id IN (SELECT ms.MainProductId 
               FROM db.MainProductToSupplierProduct ms)
      AND (p.description LIKE '%' + @filter + '%' 
           OR Coalesce(@filter,'') = '')
  </code></pre>