Managing Documents with DocumentDB Studio


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

Account keys

I assume you already have an account ; see this post on how to create an Azure DocumentDB Account. I also assume you have connection to the account in DocumentDB Studio ; see this guide to set it up.

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.

Create Documents

Now, let’s create some documents!

Select a database collection in the tree view and click the Create Document button.


Azure DocumentDB manages Json document. Let’s type a simple document:

{
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

Let’s
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.

Delete document

If you want to get rid of a document, simply click the Remove Document button and confirm you really want to delete it.


Conclusion

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!

One thought on “Managing Documents with DocumentDB Studio

  1. Pingback: Querying Collections with DocumentDB Studio | Vincent-Philippe Lauzon's blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s