title: linq query to filter with list<int> condition
body: <p>I have a list of int which is sent from the data table and I need to filter the overall list with this object.</p>
  
  <pre><code>var Ids = new List&lt;int&gt;();  
  Ids = {2, 4, 5};
  
  var result = (from m in member
                       join r in role on m.memberId equals r.memberId
                       where
                           Ids.Equals(m.memberId) &amp;&amp; r.status = 1
                       select m).ToList();
  </code></pre>
  
  <p>I struck in getting result in single query.</p>