title: How do you do an IN or CONTAINS in LINQ using LAMBDA expressions?
body: <p>I have the following Transact-Sql that I am trying to convert to LINQ ... and struggling.  </p>
  
  <pre><code>SELECT * FROM Project
  WHERE Project.ProjectId IN (SELECT ProjectId FROM ProjectMember Where MemberId = 'a45bd16d-9be0-421b-b5bf-143d334c8155')
  </code></pre>
  
  <p>Any help would be greatly appreciated ... I would like to do it with Lambda expressions, if possible.  </p>
  
  <p>Thanks in advance!</p>