...">

How to write "B" queries in WCF data services?

How to write "B" queries in Ado.Net WCF Data Services? I tried the following code.

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

But the code above does not work. I get the following error.

MyTest test failed: System.NotSupportedException: expression (([[10007] .customerId! = Null) And value (System.Collections.Generic.List 1[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 () in System.Data.Services.Client.DataServiceQuery 1.GetEnumerator() at System.Collections.Generic.List1 .. ctor (IEnumerable 1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)

+3
source share
2 answers

WCF 'WHERE IN', 'WHERE NOT IN'

+1

Source: https://habr.com/ru/post/1789747/


All Articles