Book Overview & Buying
Table Of Contents
Feedback & Rating

Guide to NoSQL with Azure Cosmos DB

By : Gaston C. Hillar, Daron Yöndem

4 (1)

Buy this Book

Guide to NoSQL with Azure Cosmos DB

4 (1)

By: Gaston C. Hillar, Daron Yöndem

Buy this Book

Overview of this book

Cosmos DB is a NoSQL database service included in Azure that is continuously adding new features and has quickly become one of the most innovative services found in Azure, targeting mission-critical applications at a global scale. This book starts off by showing you the main features of Cosmos DB, their supported NoSQL data models and the foundations of its scalable and distributed architecture. You will learn to work with the latest available tools that simplify your tasks with Cosmos DB and reduce development costs, such as the Data Explorer in the Azure portal, Microsoft Azure Storage Explorer, and the Cosmos DB Emulator. Next, move on to working with databases and document collections. We will use the tools to run schema agnostic queries against collections with the Cosmos DB SQL dialect and understand their results. Then, we will create a first version of an application that uses the latest .NET Core SDK to interact with Cosmos DB. Next, we will create a second version of the application that will take advantage of important features that the combination of C# and the .NET Core SDK provides, such as POCOs and LINQ queries. By the end of the book, you will be able to build an application that works with a Cosmos DB NoSQL document database with C#, the .NET Core SDK, LINQ, and JSON.

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Introduction to NoSQL in Cosmos DB

Making the paradigm shift to the NoSQL way

Learning about the main features of Cosmos DB

Understanding the supported NoSQL data models

Using the appropriate API for each data model

Diving deep into the Cosmos DB resource model

Understanding the system topology NoSQL

Learning about the resource hierarchy for each container

Test your knowledge

Summary

Getting Started with Cosmos DB Development and NoSQL Document Databases

Provisioning a Cosmos DB account that uses the SQL API

Understanding URIs, read-write and read-only keys, and connection strings

Creating a new document database with the SQL API

Creating a new collection

Populating a collection with documents

Understanding automatically generated key-value pairs

Understanding schema-agnostic features

Working with the web-based Azure Cosmos DB Explorer

Using Azure Storage Explorer to interact with Cosmos DB databases

Working with the Azure Cosmos DB Emulator

Test your knowledge

Summary

Writing and Running Queries on NoSQL Document Databases

Running queries against a collection with different tools

Understanding query results in JSON arrays

Checking the request units spent by a query

Working with schema-agnostic queries

Using built-in array functions

Working with joins

Using array iteration

Working with aggregate functions

Test your knowledge

Summary

Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API

Understanding the requirements for the first version of an application

Understanding the main classes of the Cosmos DB SDK for .NET Core

Creating a .NET Core 2 application to interact with Cosmos DB

Configuring a Cosmos DB client

Creating or retrieving a document database

Querying and creating document collections

Retrieving a document with an asynchronous query

Inserting documents that represent competitions

Calculating a cross-partition aggregate with an asynchronous query

Reading and updating an existing document with a dynamic object

Querying documents in multiple partitions

Calling asynchronous methods that create and query dynamic documents

Test your knowledge

Summary

Working with POCOs, LINQ, and a NoSQL Document Database

Creating models and customizing serialization

Retrieving a POCO with a LINQ asynchronous query

Inserting POCOs

Calculating a cross-partition aggregate with an asynchronous LINQ query

Reading and updating an existing document with a POCO

Querying documents in multiple partitions with LINQ

Writing LINQ queries that perform operations on arrays

Calling asynchronous methods that use POCOs to create and query documents

Inspecting the SQL API queries that LINQ generates

Test your knowledge

Summary

Tuning and Managing Scalability with Cosmos DB

Understanding request units and how they affect billing

Dynamically adjusting throughput for a collection with the Azure portal

Working with client-side throughput management

Understanding rate limiting and throttling

Tracking consumed request units with client-side code

Understanding the options for provisioning request units

Learning portioning strategies

Deploying to multiple regions

Understanding the five consistency levels

Taking advantage of regional failover

Understanding indexing in Cosmos DB

Checking indexing policies for a collection with the Azure portal

Test your knowledge

Summary

Answers

Chapter 1: Introduction to NoSQL in Cosmos DB

Chapter 2: Getting Started with Cosmos DB Development and NoSQL Document Databases

Chapter 3: Writing and Running Queries on NoSQL Document Databases

Chapter 4: Building an Application with C#, Cosmos DB, a NoSQL Document Database, and the SQL API

Chapter 5: Working with POCOs, LINQ, and a NoSQL Document Database

Chapter 6: Tuning and Managing Scalability with Cosmos DB

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

4 (1)

5 star

4 star

100%

3 star

2 star

1 star

Creating a .NET Core 2 application to interact with Cosmos DB

Now we will create a new multiplatform .NET Core 2 console app. We will install the necessary NuGet packages to work with the Cosmos DB SDK and make it easy to use a JSON configuration file for our application.

In Visual Studio, select File | New | Project and select Visual C# | .NET Core | Console App (.NET Core). Enter SampleApp1 for the project name. The code file for the sample is included in the learning_cosmos_db_04_01 folder in the dot_net_core_2_samples/SampleApp1/SampleApp1.sln file.

Install the NuGet packages and versions detailed in the next table. If there are newer versions available, you will have to verify the change log to make sure that there are no breaking changes. The sample has been tested with the specified versions: