Как использовать параметризованный в пункте в космосе с определением запроса? ⇐ C#

[Гость]

У меня есть запрос, который работает, когда я создаю в качестве строки, но когда я использую QueryDefinition и передаю его как параметр, в предложении не работает.
Как это исправить?
Здесь, Allstocknumbers будет "11", 22 " и абонент. "Somestring"
Работа:
var allStockNumbers = string.Join(", ", stockNumbers.Select(x => "\"" + x + "\""));
var query = !string.IsNullOrWhiteSpace(filters?.LineItemState)
? $"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, ARRAY(SELECT * FROM c IN f.lineItems where c.itemState = {"\"" + filters.LineItemState + "\"" }) as lineItems FROM f WHERE f.stockNumber IN ({allStockNumbers})"
: $"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, f.lineItems FROM f WHERE f.stockNumber IN ({allStockNumbers})";
< /code>
не работает: < /p>
var allStockNumbers = string.Join(", ", stockNumbers.Select(x => "\"" + x + "\""));
QueryDefinition query;
if (!string.IsNullOrWhiteSpace(filters?.LineItemState))
{
var lineItemState = "\"" + filters.LineItemState + "\"";
query = new QueryDefinition(
@"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, ARRAY(SELECT * FROM c IN f.lineItems where c.itemState = @lineItemState) as lineItems FROM f WHERE f.stockNumber IN (@allStockNumbers)"
).WithParameter("@lineItemState", @lineItemState)
.WithParameter("@allStockNumbers", allStockNumbers);
}
else
{
query = new QueryDefinition(
@"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, f.lineItems FROM f WHERE f.stockNumber IN (@allStockNumbers)"
).WithParameter("@allStockNumbers", allStockNumbers);
}

Я также пытался с array_contains , но то же самое:
var allStockNumbers = string.Join(", ", stockNumbers.Select(x => "\"" + x + "\""));
QueryDefinition query;
if (!string.IsNullOrWhiteSpace(filters?.LineItemState))
{
var lineItemState = "\"" + filters.LineItemState + "\"";
query = new QueryDefinition(
"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, ARRAY(SELECT * FROM c IN f.lineItems where c.itemState = @lineItemState) as lineItems FROM f WHERE ARRAY_CONTAINS(@allStockNumbers, f.stockNumber)"
).WithParameter("@lineItemState", lineItemState)
.WithParameter("@allStockNumbers", allStockNumbers);
}
else
{
query = new QueryDefinition(
@"SELECT f.id, f.location, f.stockNumber, f.vin, f.totalCarliCost, f.totalCostSubmitted, f.createdDateTime, f.createdBy, f.earliestPaymentDate, f.paymentItems, f.lineItems FROM f WHERE f.stockNumber IN (@allStockNumbers)"
).WithParameter("@allStockNumbers", allStockNumbers);
}


Подробнее здесь: https://stackoverflow.com/questions/764 ... definition