Select distinct on DocumentDB and C#

Question

I am having a challenge retrieving data from my DocumentDB using C#.

I get the expected results when I run the query below in my Azure DocumentDB data explorer. Ignore the use of contains query, it's a dynamically crafted query

select distinct c.model from c   where  ( CONTAINS (c.manufacturer, \"BMW\") )

Attempting to run the same query on c# gives me an error

var dblink = UriFactory.CreateDocumentCollectionUri(ConfigurationManager.AppSettings["DocumentDbDatabase"], "Conversation");
var models = _dbclient.CreateDocumentQuery<dynamic>(dblink, "select distinct c.model from c   where  ( CONTAINS (c.manufacturer, "BMW") )").ToList();

The error I get is incorrect syntax near distinct

Where is the error emanating from?

If you have strongly typed objects, you might as well try LINQ — bit, Sep 05 '18 at 07:56
@RafatSarosh I already did that. the query however is breaking at the second word which is distinct — Masinde Muliro, Sep 05 '18 at 12:02

score 0 · Answer 1 · edited Sep 07 '18 at 22:38

0

You may want to upgrade to the latest .Net SDK (v1.22.0).

The syntax error here is from the SDK rather than the query service, given that support for DISTINCT was added recently. Upgrading to the latest SDK should fix the issue.

edited Sep 07 '18 at 22:38

Samuel Liew

76,741
107
159
260

answered Sep 05 '18 at 15:32

Samer Boshra

869
5
6

Select distinct on DocumentDB and C#

1 Answers1