title: How to do a linq query with a IN
body: <p>I'm pretty new with linq and i would like to do this query :</p>
  
  <pre><code>select *
  FROm dbo.PremiseProviders p
  where p.premiseProviderId IN
    (select a.premiseproviderId
    FROM dbo.PremiseProviderAddresses a, dbo.premiseProviderAddressVersions v
    where a.premiseprovideraddressId = v.premiseprovideraddressId
    and v.postcode = '84280')
  </code></pre>
  
  <p>But i have no idea how to do the IN part, with the second Select, can someone help?
  Thx</p>