How can I trace the query produced by the documentdb Linq provider?

Question

How can I see the document DB sql query (in a string) generated by a linq statement before it gets sent to the server?

_documentClient.CreateDocumentQuery<MyType>(
                        UriFactory.CreateDocumentCollectionUri(DatabaseName,
                            CollectionName)).Where(....).SelectMany(...)

I want to use this for tracing purposes.

Answer 1

You can call ToString() on the DocumentDB query to get the SQL translation of the LINQ expression that's sent over the wire.

string sql = client.CreateDocumentQuery<MyType>(collectionUri).Where(t => t.Name = "x").ToString();
// sql is somthing like SELECT * FROM c WHERE c["Name"] = "x"

Answer 2

You could just use Fiddler and view the JSON of the request after it is sent.

View an example here:

CosmosDB\DocumentDB Generated SQL Query