title: Use linq equivalent of sql IN operator
body: <p>I have following linq statement in which I want to use linq equivalent of SQL IN operator. I have a string variable having values like  {1,2}. </p>
  
  <pre class="lang-cs prettyprint-override"><code>    string items = "1,2";
      var objList = from p in db.firsttable 
                    join q in db.secondtable on q.id equals p.someid
                    where items.Contains(p.id)
                    select new 
                    {
                      p.id,
                      p.column1,
                      p.column2,
                      q.column3
  
                    }
  </code></pre>
  
  <p>But I am unable to get the output from the above linq statement. Please help me out.</p>