title: LINQ to SQL where in (lambda syntax)
body: <p>Can someone help me with this please?  I would like a simple 'where in'.  Here's the SQL that does what I want.</p>
  
  <pre><code>select ur.RoleID
  from UserRoles ur
  where ur.RoleID in (5, 15)
  </code></pre>
  
  <p>And here's my attempt.  The method .IN() doesn't exist obviously, just put my aggrevated thoughts lol.</p>
  
  <pre><code>int roleid;
  foreach (data r in dataList) {
      using (DataContext communityContext = new DataContext()) {
          roleid = communityContext.UserRoles
              .Where(x =&gt; x.UserID == r.ClientId &amp;&amp; x.RoleID.IN(5, 15))
              .Select(x =&gt; x.RoleID)
              .First();
      }
  }
  </code></pre>