DocumentDB SQL string works in Query Explorer but not in C# code

Question

When I run this query in the Query Explorer…

Select quote from sqs quote
join product in quote.QuotedProductList 
join part in product.PartNumberList 
WHERE part.id = 'Part-XXXX-XX' AND quote.QuoteStatus = 'Draft'

..in DocumentDB I get two quotes with the appropriate product and part data showing in the results pane; this is correct. But, when I create the same query in C# I get two quote objects returned that have been created by the constructor but there is no data from the database…

List<Quote> hits = new List<Quote>();
            string sql = "Select quote from sqs quote join product in quote.QuotedProductList join part in product.PartNumberList WHERE part.id = '" + partNumber + "' AND quote.QuoteStatus = 'Draft'";
hits = Client.CreateDocumentQuery<Quote>(Collection.DocumentsLink, sql).ToList();

Can anyone explain why this happening?

Howard Edidin · Accepted Answer · 2016-01-14 18:55:08Z

1

Try this

Select quote.quote from sqs quote join product in quote.QuotedProductList join part in product.PartNumberList WHERE part.id = '" + partNumber + "' AND quote.QuoteStatus = 'Draft'";

answered Jan 14, 2016 at 18:55

Howard Edidin

631 silver badge9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DocumentDB SQL string works in Query Explorer but not in C# code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related