entity-framework - 如何在 WCF 数据服务中编写 'In' 查询？

Question

如何在 Ado.Net WCF 数据服务中编写“In”查询？我试过下面的代码。

IList<int> orderIds = new List<int> { 59810, 59811, 59812, 59813, 59814 };
var lstorders = _context.Orders
                        .Where(o => orderIds.Contains(o.customerId))
                        .ToList<Orders>();

但是上面的代码是行不通的。我收到以下错误。

Test 'MyTest' failed: System.NotSupportedException : The expression (([10007].customerId != null) And value(System.Collections.Generic.List1[System.Int32]).Contains([10007].customerId.Value))
is not supported.
at System.Data.Services.Client.ExpressionWriter.ExpressionToString(DataServiceContext
context, Expression e)
at System.Data.Services.Client.UriWriter.VisitQueryOptionExpression(FilterQueryOptionExpression
fqoe)
at System.Data.Services.Client.UriWriter.VisitQueryOptions(ResourceExpression
re)
at System.Data.Services.Client.UriWriter.VisitResourceSetExpression(ResourceSetExpression
rse)
at System.Data.Services.Client.DataServiceALinqExpressionVisitor.Visit(Expression
exp)
at System.Data.Services.Client.UriWriter.Translate(DataServiceContext
context, Boolean addTrailingParens,
Expression e, Uri& uri, Version&
version)
at System.Data.Services.Client.DataServiceQueryProvider.Translate(Expression
e)
at System.Data.Services.Client.DataServiceQuery1.Execute() at System.Data.Services.Client.DataServiceQuery1.GetEnumerator()
at System.Collections.Generic.List1..ctor(IEnumerable1
collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)

Answer 1

这可能会有所帮助。

Select entities where ID in int array - WCF Data Services, LINQ