title: linq to sql return only match based on ID
body: <p>I am using VB.Net and have two list. I want to return only the ones that have a match based on the ids from tempProduct2. My linq is incorrect, is there a way to do this with linq to sql? </p>
  
  <pre><code>dim newList as List(Of Product)
  dim tempProduct1 as List(Of Product)
  dim tempProduct2 as List(Of Product)
  
  
  newList = (From p1 In tempProduct1 
             Where tempProduct2 (Of ?).Contains(p2.ID)
             Select p1).ToList()
  </code></pre>