title: Select distinct on DocumentDB and C#
body: <p>I am having a challenge retrieving data from my DocumentDB using C#.</p>
  
  <p>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</p>
  
  <pre><code>select distinct c.model from c   where  ( CONTAINS (c.manufacturer, \"BMW\") )
  </code></pre>
  
  <p>Attempting to run the same query on c# gives me an error</p>
  
  <pre><code>var dblink = UriFactory.CreateDocumentCollectionUri(ConfigurationManager.AppSettings["DocumentDbDatabase"], "Conversation");
  var models = _dbclient.CreateDocumentQuery&lt;dynamic&gt;(dblink, "select distinct c.model from c   where  ( CONTAINS (c.manufacturer, "BMW") )").ToList();
  </code></pre>
  
  <p>The error I get is <code>incorrect syntax near distinct</code></p>
  
  <p>Where is the error emanating from?</p>