Convert SQL to lambda in C#
<p>How can I re-write the following query from SQL to lambda in C#? Is it recommended to write in lambda?</p>

<pre><code>SELECT * 
FROM Claims 
WHERE id IN (SELECT claimId 
             FROM MissingItems 
             GROUP BY claimId);
</code></pre>