title: SubQuery to a local list using ObjectQuery
body: <p>I need to find all records where the status is in the local list of Integer's.
  In SQL I would do </p>
  
  <pre><code>Where Status in (select i from my list)
  </code></pre>
  
  <p>But I can't figure how to make it happen in Linq.</p>
  
  <pre><code>ListData = New IssueTrackerEntities2()
  
  Dim queryString As String = "SELECT VALUE CallList FROM IssueTrackerEntities2.CallList AS CallList"
  
      Dim Status As New List(Of Integer)
  
      queryString += "Where CallList.AssignToValue = @AssignTo"
  
      Dim TicketQuerys As New ObjectQuery(Of CallList)(queryString, ListData)
  
      TicketQuerys.Parameters.Add(New ObjectParameter("AssignTo", AssignToFilter.EditValue))
  </code></pre>