Azure Cosmos DB: Table API

Learn how to provision a NoSQL database with CosmosDB.

Introduction

• NoSQL table data in Cosmos DB
• What you should know
• Programming setup and configuration
• How to access the sample code on GitHub

1. Getting Started

• Cosmo DB API types
• Table storage basics
• Table storage versus Cosmos DB Table API
• SQL API vs. Table API
• Resource model
• Partitioning data

2. Create Tables in Azure Portal

• Create database account
• Examine the database account
• Create a table in the Azure portal
• Examine the sample data
• Add data to table in Azure Data Explorer
• Query data in Azure Data Explorer

3. Data Operations and Queries

• Choose an SDK
• Open the sample project
• Configure DB connection info with .json files
• Load configuration data
• Connect to the database
• Work with Tables
• Get table rows with TableClient
• Get table rows with typed entity class
• Update, insert, and delete rows
• Work with single row
• Query data with LINQ expression
• Batch operations

4. Migrate from Table Storage

• Install Table Explorer and the Data Transfer tools
• The legacy project
• Migrate data
• Guidance on API differences
• Change the connection string
• Change the code

Conclusion

• Next steps