使用 ObjectQuery 对本地列表进行子查询

Question

我需要查找状态位于整数本地列表中的所有记录。 在 SQL 中我会这样做

Where Status in (select i from my list)

，但我不知道如何在 Linq 中实现它。

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))

Answer 1

Contains 扩展方法是您正在搜索的运算符。

int[] localList = {1, 2, 3, 4};
var allItems = GetAllItems();
var filteredItems = from i in allItems where localList.Contains(i.Status) select i;