Azure：新しいDocumentDB NoSQL Service、新しい検索サービス、新しいSQL AlwaysOn VMテンプレートなど

// AndersonFamily.json file
{
    "id": "AndersenFamily",
    "lastName": "Andersen",
    "parents": [
        { "firstName": "Thomas" },
        { "firstName": "Mary Kay" }
    ],
    "children": [
        { "firstName": "John", "gender": "male", "grade": 7 }
    ],
    "pets": [
        { "givenName": "Fluffy" }
    ],
    "address": { "country": "USA", "state": "WA", "city": "Seattle" }
}

// WakefieldFamily.json file
{
    "id": "WakefieldFamily",
    "parents": [
        { "familyName": "Wakefield", "givenName": "Robin" },
        { "familyName": "Miller", "givenName": "Ben" }
    ],
    "children": [
        {
            "familyName": "Wakefield",
            "givenName": "Jesse",
            "gender": "female",
            "grade": 1
        },
        {
            "familyName": "Miller",
            "givenName": "Lisa",
            "gender": "female",
            "grade": 8
        }
    ],
    "pets": [
        { "givenName": "Goofy" },
        { "givenName": "Shadow" }
    ],
    "address": { "country": "USA", "state": "NY", "county": "Manhattan", "city": "NY" }
}

using (client = new DocumentClient(new Uri(endpoint), authKey))
{
    var database = new Database { Id = "ScottsDemoDB" };
    database = await client.CreateDatabaseAsync(database);
 
    var collection = new DocumentCollection { Id = "Families" };
    collection = await client.CreateDocumentCollectionAsync(database.SelfLink, collection);
 
    // DocumentDBは強く片付けされたPOCO、dynamicオブジェクトをサポート
 supports strongly typed POCO objects and also dynamic objects
    dynamic andersonFamily =  JsonConvert.DeserializeObject(File.ReadAllText(@".\Data\AndersonFamily.json"));
    dynamic wakefieldFamily = JsonConvert.DeserializeObject(File.ReadAllText(@".\Data\WakefieldFamily.json"));
 
    // DocumentDBに文書を保存
    await client.CreateDocumentAsync(collection.SelfLink, andersonFamily);
    await client.CreateDocumentAsync(collection.SelfLink, wakefieldFamily);
 
    // シンプルなWHERE句にマッチしたJSON文書を返すシンプルなクエリー
    var query = client.CreateDocumentQuery(collection.SelfLink, "SELECT * FROM Families f WHERE f.id = 'AndersenFamily'");
    var family = query.AsEnumerable().FirstOrDefault();
 
    Console.WriteLine("The Anderson family have the following pets:");              
    foreach (var pet in family.pets)
    {
        Console.WriteLine(pet.givenName);
    }
 
    // 子供の性別が男とである家族の子供情報だけを取得
    query = client.CreateDocumentQuery(collection.DocumentsLink, "SELECT * FROM c IN Families.children WHERE c.gender='male'");
    var child = query.AsEnumerable().FirstOrDefault();
 
    Console.WriteLine("The Andersons have a son named {0} in grade {1} ", child.firstName, child.grade);
 
    // テストデータベースをクリーンアップ
    await client.DeleteDatabaseAsync(database.SelfLink);
}

function SwapPets(family1Id, family2Id) {
    var context = getContext();
    var collection = context.getCollection();
    var response = context.getResponse();
 
    collection.queryDocuments(collection.getSelfLink(), 'SELECT * FROM Families f where f.id  = "' + family1Id + '"', {},
    function (err, documents, responseOptions) {
        var family1 = documents[0];
 
        collection.queryDocuments(collection.getSelfLink(), 'SELECT * FROM Families f where f.id = "' + family2Id + '"', {},
        function (err2, documents2, responseOptions2) {
            var family2 = documents2[0];
                   
            var itemSave = family1.pets;
            family1.pets = family2.pets;
            family2.pets = itemSave;
 
            collection.replaceDocument(family1._self, family1,
                function (err, docReplaced) {
                    collection.replaceDocument(family2._self, family2, {});
                });
 
            response.setBody(true);
        });
    });
}

// ストアドプロシージャを登録
StoredProcedure storedProcedure = new StoredProcedure
{
    Id = "SwapPets",
    Body = File.ReadAllText(@".\JS\SwapPets.js")
};
           
storedProcedure = await client.CreateStoredProcedureAsync(collection.SelfLink, storedProcedure);

// 家族間でペットを入れ替えるストアドプロシージャを実行
dynamic result = await client.ExecuteStoredProcedureAsync<dynamic>(storedProcedure.SelfLink, "AndersenFamily", "WakefieldFamily");