I released a second Beta of DocumentDB Studio (release 0.2.0.1).
DocumentDB Studio is to Azure DocumentDB what SQL Management Studio is to SQL Server and SQL Azure: a one-stop shop to manage and interact with your DocumentDB.
I posted an installation guide of the application and an upgrade guide (both very simple). I also posted a guide to Manage Databases and collections in DocumentDB Studio.
In this post I want to walk you through the new features of release 0.2.0.1:
- Disconnect an account
- Create Documents
- List documents under collection
- View document from the collection
- Delete document
I finally assume you have at least a collection setup ; see this guide to set it up otherwise.
Disconnect an account
First, a trivial feature that was nevertheless missing from the first beta: the ability to disconnect Studio from an account.
In the toolbar, click the Disconnect button:
and confirm you really want to disconnect in the dialog box.
Now, let’s create some documents!
Select a database collection in the tree view and click the Create Document button.
firstName : “Vincent-Philippe”,
lastName : “Lauzon”,
isActive : true
Simply note that json rules and types apply. Here I used strings (in double quotes) and boolean (true without quotes).
Then click OK to save the document to Azure DocumentDB.
List documents under collection
You should see the document appear under your collection as a guid.
Let’s add a few other documents. DocumentDB Studio remembers the last JSON document you enter in that collection, which is a nice starting point.
View document from the collection
select one of those document:
This gives us a read-only view of the document.
You will notice the JSON document displayed is your original JSON document plus a couple of meta-data fields added by Azure DocumentDB. The most important of those fields is the id. The id is auto-generated but you can also enter manually when you type the document ; it identifies the document uniquely within a collection.
If you want to get rid of a document, simply click the Remove Document button and confirm you really want to delete it.
This release a few key feature allowing you to explore Azure DocumentDB.
The next key feature to be implemented is collection querying.
If you have any feedback on DocumentDB Studio, please do not hesitate to use the discussion board!