Just wondering if this tool is being updated to add more features (e.g. better query editor etc.)?

Using VS-2015 (Enterprise).
#1 Restoring NuGet on Build, fails.
#2 All references cannot be found, e.g. System, System.net.
< Installed .NET Frameworks >
.NET FW 2.0 SP 2 (CLR:2.0)
.NET FW 3.0 SP 2 (CLR:2.0)
.NET FW 3.5 SP 1 (CLR:2.0)
.NET FW 4.6.1 (CLR:4.0)

Severity Code Description Project File Line Suppression State
Error This project references NuGet package(s) that are missing on this computer. Enable NuGet Package Restore to download them. For more information, see http://go.microsoft.com/fwlink/?LinkID=322105. The missing file is ..\packages\Microsoft.Azure.DocumentDB.1.10.0\build\Microsoft.Azure.DocumentDB.targets. DocumentDBStudio C:\temp\DocumentDBStudio-master\DocumentDBStudio-master\DocumentDBStudio\DocumentDBStudio.csproj 315

Any help appreciated,
Michael

Error pops up when expanding a database:

Error

Error while reading the databases.

Message: {"Errors":["The collection 'main' could not be read because it was created with a newer API version."]}

ActivityId: a0738b17-e9ad-4f04-8662-4e76994594c0, Request URI: [snip]

OK

This project is called "Azure DocumentDB Studio", or "DocumentDbStudio" for short.

There is another project that is called "DocumentDB Studio", or "StudioDocDB" for short.
https://studiodocumentdb.codeplex.com/

Two different projects having the same name and very similar functionality is quite confusing. Can you guys have a chat and pick different names? Or maybe merge your projects?

It would be great if hitting something like Control + Enter or F5 would execute a query.

It would be great if I can delete or replace documents that are returned from a query. I happens often that the to be deleted document is not present in the tree on the left and therefore sadly not deletable via the DocumentDb Studio.

Steps to reproduce:

1. Read an existing Document Collection
2. Click replace Document Collection
3. Make some changes to the Index Policy
4. Click Execute
5. See the message Replace DocumentCollection succeed!
6. Read the Document Collection again... the index policy does not appear to update.

When querying a collection, all returned JSON results as collapsed. Is there a way to configure the app to expand all the returned elements? Having to click every {...} element to see what it is is far from ideal.

Do plan for an upgrade on the client, as few feature set doesn't work as expected on 1.11.1 for example auto split of partition collection is not enabled by default.
We ended up in soup (intermittently) just because we ended up accessing our cosmos db account via this version "1.11.1".

https://help.github.com/articles/open-source-licensing/

Thanks!

The unsorted treeview makes it hard to find a document by id. Sort the treeview to make it easier.

Is it possible to delete multiple documents at a time?

Is it possible to delete a document directly after selecting "Delete Document", instead of clicking "Execute" additionally?

Very useful tool. It would be nice if we could specify the MaxItemCount for the documents feed for the tree, to be passed to ReadDocumentFeedAsync here.

When trying to create a procedure the following error is generated:

Microsoft.Azure.Documents.DocumentClientException: The input authorization token can't serve the request. Please check that the expected payload is built as per the protocol, and check the key being used. Server used the following payload to sign: 'post
sprocs
dbs/pmg-docdb-rd-test/colls/JobResults
wed, 18 jan 2017 12:37:21 gmt

'
ActivityId: 9c6d35b9-fbf6-4727-9dda-98a88bb0fc43
at Microsoft.Azure.Documents.Client.ClientExtensions.d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.GatewayStoreModel.<>c__DisplayClass10.<<InvokeAsync>b__f>d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.Documents.BackoffRetryUtility1.<>c__DisplayClass2.<<ExecuteAsync>b__0>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.Documents.BackoffRetryUtility1.<ExecuteRetry>d__1b.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.Azure.Documents.BackoffRetryUtility1.d__1b.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.BackoffRetryUtility1.d__a.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.GatewayStoreModel.<InvokeAsync>d__1f.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.Documents.GatewayStoreModel.d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.Client.DocumentClient.<CreateAsync>d__2ea.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.Documents.Client.DocumentClient.d__84.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.BackoffRetryUtility1.<>c__DisplayClass2.<b__0>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Microsoft.Azure.Documents.BackoffRetryUtility1.d__1b.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Azure.Documents.BackoffRetryUtility1.<ExecuteRetry>d__1b.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.Documents.BackoffRetryUtility1.<ExecuteAsync>d__a.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult()
at Microsoft.Azure.DocumentDBStudio.StoredProcedureNode.d__5.MoveNext() in C:\projects\DocumentDBStudio\DocumentDBStudio\Nodes\StoredProcedureNode.cs:line 70

It would be awesome to have the ability to have concurrent query/action windows as to not have to use notepad as a temporary clipboard. Something similar to SQL Server Management Studio tabs.

Thanks for all the hard work!

One of the major problem I have when using DocumentDBStudio as a query playground is the fact that some properties are not shown in the GUI.

See

it is as if the property does not contain anything but if I look on fiddler this property is populated

1. Open client
2. Browse to a document collection
3. Right click and choose query documents
4. select * from c where c.partitionKey <> "somevalue" -- in my case some value is a guid
5. Execute query
6. Crash below

System.AccessViolationException was unhandled
Message: An unhandled exception of type 'System.AccessViolationException' occurred in Microsoft.Azure.Documents.Client.dll
Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

This tool doesn't seem to support UTF.

1. Seems all underscore fields are hided, which is not right. It should only hide _ts, _etag, _self, _rid, _attachments etc.

2. Press the button doesn't toggle the display, which give the feeling that is not working at all.