<html><body><h2 style="text-align:justify;">1. Install Azure Cosmos Db Emulator</h2><ul><li style="text-align:justify;">You can try this link to download: <a href="https://learn.microsoft.com/en-us/azure/cosmos-db/local-emulator?tabs=ssl-netstd21">Install and develop locally with Azure Cosmos DB Emulator</a></li><li style="text-align:justify;">Step-by-step: follow <a href="https://careers.saigontechnology.com/blog-detail/azure-cosmos-db-overview#toc_2">this topic</a></li></ul><h2 style="text-align:justify;">2. Step by step</h2>This topic will use .NET 6.0 &amp; Visual Studio 2022<h3 style="text-align:justify;">Step 1: New project</h3><ul><li style="text-align:justify;">Create ASP .NET Core Web API</li></ul><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-FbtRD6kns5tpRNp6xnoa0GehQ93cITG6EFgeG5Nh.png"><ul><li style="text-align:justify;">Input project name</li></ul><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-3fesVkXPIpxxAEQZTCstHPrlaSBiCTDEfOkqbfjI.png"><ul><li style="text-align:justify;">Select framework</li></ul><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-yVyUIv5ekDfHjbYyNawgkYP9gkV7BluuhzvfhMxr.png"><ul><li style="text-align:justify;">Result</li></ul><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-lyFyg0RRcYghuGbSZwhD2PhMZilue1OdqeEcykmY.png"><ul><li style="text-align:justify;">Add infrastructure folders</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-n9THOXkmjbV8BhiBgDcOt3u1WcLplzb96z5edK1g.png"></figure><ul><li style="text-align:justify;">Enums: Store enumerations, default values, and constant values here.</li><li style="text-align:justify;">Models: Contain DTOs, object definitions: API response, app settings, etc.</li><li style="text-align:justify;">Options: Cosmos client options will be saved here.</li><li style="text-align:justify;">QueryBuilders: Define queries for CosmosDb here.</li><li style="text-align:justify;">Services: we could gather services here: cosmosDb, deployment services, etc.</li></ul><h3 style="text-align:justify;">Step 2: Add cosmosdb services</h3><ul><li style="text-align:justify;">CosmosDb services will have the following:<ul><li style="text-align:justify;">ILogger: used to log information, error, and warning.</li><li style="text-align:justify;">IConfiguration: we stored the database connection in the configuration file, and we need IConfiguration to read data from the configuration file.</li></ul></li><li style="text-align:justify;">Define services here: <ul><li style="text-align:justify;">The first function we need is: GetConnection()</li></ul></li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-ppbHDcryxRENalyoHIgptTLCl99uu24fyycyu85K.png"></figure><ul><li style="text-align:justify;">Private function, cannot be called outside CosmosDb Services</li><li style="text-align:justify;">Get CosmosConnection by using the connection string, environment, and client options from app settings.</li><li style="text-align:justify;">Steps:<ul><li style="text-align:justify;">Create CosmosClient by using a connection string and cosmos client options</li><li style="text-align:justify;">Get the database by using CosmosClient.</li></ul></li><li style="text-align:justify;">Then, we will need a get container function: GetContainer(string containerName)</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-9X1NLPsaMDXDCEGVW676BEoC0Kgstgfj73OxV1Yl.png"></figure><ul><li style="text-align:justify;">The same with GetConnection(), this one is a private function as well.</li><li style="text-align:justify;">We need to create container first, then container will be used to execute query, update, insert, or delete the item.</li><li style="text-align:justify;">At database explorer, click on … to create new container</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-tnybnsT0phg0Eek3NCCXeyAZikO91EyR5nq3Lo22.png"></figure>  <ul><li style="text-align:justify;">Input container name and partition key</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-ujvbtteg2hikiOkNCoULelIDn2lz3JUBod9hYg3Y.png"></figure><ul><li style="text-align:justify;">Input provision throughput</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-k4tff6mQBJS6QPbsP2sj7l66FAx7eBoQUnx9Vg5D.png"></figure><ul><li style="text-align:justify;">Execute:<ul><li style="text-align:justify;">Get container then execute.</li><li style="text-align:justify;">Log the request charge.</li><li style="text-align:justify;">The asynchronous function name should have “async” suffix.</li><li style="text-align:justify;">Get list items</li></ul></li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-WpC2Yxypwj5BWHaj3IAv7qkn7LOJrD7CnOvbieqo.png"></figure>query items<ul><li style="text-align:justify;">Using query definition. For example: select * from c order by c._ts DESC</li><li style="text-align:justify;">Need to know the container name. In the Azure Cosmos Database, data is stored as documents in containers.</li><li style="text-align:justify;">Update item</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-tU4BvYnz7FS9SzcMupWI5KSjuwi4KXWudKXoeoPT.png"></figure>update item<ul><li style="text-align:justify;">Container name is mandatory</li><li style="text-align:justify;">The partition key acts as a logical partition, every single object has to have a property, which is considered the partition key. In this topic, we consider Type as the partition key. That means Type will exist on every single object.</li><li style="text-align:justify;">Selecting a partition key for container is a very important design choice in Azure Cosmos DB. Be careful when selecting which property is the partition key. For example, if id serves as the partition key, and we have over 1000 documents in the container, and there are over 1000 unique id, that means we will have over 1000 partition keys, and the container will be split into over 1000 logical partitions. That’s why the partition key should have a high cardinality. To put it simply, the partition key should have a wide range of possible values.</li><li style="text-align:justify;">Partition key has two components:  partition key path and partition key value. In this topic, partition key path = /Type, partition key value = value of Type property.</li><li style="text-align:justify;">Type value cannot be updated.</li><li style="text-align:justify;">For example: </li></ul><pre><code class="language-plaintext">{
    "id": "b9572c40-56bc-42b4-8bee-8f8dbd650435",
    "Type": "DeploymentRequest"
}</code></pre><ul><li style="text-align:justify;">partition key path = /Type</li><li style="text-align:justify;">partition key value =  DeploymentRequest</li><li style="text-align:justify;">DeploymentRequest cannot be changed</li><li style="text-align:justify;">The <a href="https://www.rfc-editor.org/rfc/rfc8259#section-6">JSON specification</a> calls out that the partition key should only contain string values or you will get into trouble with interoperability problems. </li><li style="text-align:justify;">Insert item</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-CZ6fhtC5lgXdZHMa7ohEu29wlSzZC0AzPzGnzMxq.png"></figure>insert item<ul><li style="text-align:justify;">Container name is required</li><li style="text-align:justify;">Item is any object we want, with Type property because Type is the partition key</li><li style="text-align:justify;">If an item does not have an id, then after the item is inserted successfully, an id will be generated automatically with other system properties: _rid, _self, _etag, _attachments, _ts</li><li style="text-align:justify;">Example: </li></ul><pre><code class="language-plaintext">{
    "id": "b9572c40-56bc-42b4-8bee-8f8dbd650435",
    "Type": "DeploymentRequest",
    "Version": "v4.0.0",
    "VersionStatus": "Missing",
    "Environment": "DEV",
    "Status": "ResourcePending",
    "CreatedUser": "tu.phan@saigontechnology.com",
    "DeploymentDate": "2022-03-22T07:28:06.947Z",
    "CreatedDate": "2022-03-22T07:28:13.2721979Z",
    "Latest": true,
    "HasApprove": false,
    "_rid": "ug1nALpRWxcBAAAAAAAAAA==",
    "_self": "dbs/ug1nAA==/colls/ug1nALpRWxc=/docs/ug1nALpRWxcBAAA==/",
    "_etag": "\"00000000-0000-0000-d6e9-2895e3e001d8\"",
    "_attachments": "attachments/",
    "_ts": 1664774990
}</code></pre><ul><li style="text-align:justify;">Delete an item by id</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-HaetarOEs5MdiZf6W1Hu8fzSxUkpHhgya7bpgCHr.png"></figure>delete item<ul><li style="text-align:justify;">Container name and partition key is mandatory</li><li style="text-align:justify;">id is required, cosmos will delete the document based on document id</li><li style="text-align:justify;">Example: <ul><li style="text-align:justify;">id = "b9572c40-56bc-42b4-8bee-8f8dbd650435"</li><li style="text-align:justify;">partitionKey = "b9572c40-56bc-42b4-8bee-8f8dbd650435"</li><li style="text-align:justify;">containerName = "deployment"</li></ul></li></ul><h3 style="text-align:justify;">Step 3: Add deployment services</h3><ul><li style="text-align:justify;">CosmosServices class is a dependency of deployment services class.</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-CSTmV0qv4KfjFb7lxH0OwJEd42nxPDkl3R5qHnrU.png"></figure><ul><li style="text-align:justify;">Cosmos services are used to save/get deployment request into/from the database<ul><li style="text-align:justify;">Get deployment requests</li></ul></li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-LUblFd8YgrvLhoTbvK1xSXw2xTsYo1NalfOjdxeF.png"></figure><ul><li style="text-align:justify;">Define query as QueryDefinition</li><li style="text-align:justify;">Ex: Get all latest documents with type = DeploymentRequest, order by _ts descending</li></ul>SELECT VALUE cFROM cWhere c.Type = @Type and c.Latest = trueORDER BY c._ts DESC@Type = “DeploymentRequest”<ul><li style="text-align:justify;">Provide container name = deployment</li><li style="text-align:justify;">Partition Key is optional</li><li style="text-align:justify;">Insert deployment</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-w7nP3RwWFCkm77G819Xjc7Mr8XC4uINYglcGTEot.png"></figure><ul><li style="text-align:justify;">input param is the deployment object.</li><li style="text-align:justify;">when inserting, that’s means we are creating a new document, no need to have an id property, if it is missing, it will be generated automatically.</li><li style="text-align:justify;">We should provide container name, and partition key when using cosmos services to insert deployment into database. Because we are considering the input used to insert is an object, we should not get partition key value from the input.</li><li style="text-align:justify;">Ex:</li></ul><pre><code class="language-plaintext"> {
    "Type": "DeploymentRequest",
    "Version": "v4.0.0",
    "VersionStatus": "Missing",
    "Environment": "DEV",
    "Status": "ResourcePending",
    "CreatedUser": "tu.phan@saigontechnology.com",
    "DeploymentDate": "2022-03-22T07:28:06.947Z",
    "CreatedDate": "2022-03-22T07:28:13.2721979Z",
    "Latest": true,
    "HasApprove": false
}</code></pre><ul><li style="text-align:justify;">Update deployment</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-9k017UTGt06ie8tsaNuMF3gzAg9qiDu73312fQO5.png"></figure><ul><li style="text-align:justify;">Input param is the deployment object</li><li style="text-align:justify;">When updating, id, and type are required. If id is missing, container cannot update document, and we will get an error message.</li></ul><h3 style="text-align:justify;">Step 4: Add deployments controller</h3><ul><li style="text-align:justify;">DeploymentServices class is a dependency of the deployment controller class.</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-77g1nFIUpV61NUlEYvkevFt2ay9IdTNGMLHr4JUV.png"></figure><ul><li style="text-align:justify;">The result will be converted to OkObjectResult.</li><li style="text-align:justify;">Define APIs here:<ul><li style="text-align:justify;">Get all deployments</li></ul></li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-2VK6P0AAPHGPwIBkIwRO9N2OIGxDdGgK7AxgOb1d.png"></figure><ul><li style="text-align:justify;">HTTP GET method.</li><li style="text-align:justify;">No need param, we can pass params for pagination purposes later.</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-TMnb7RRsje1jtP1BkPdvJUu8Xvi7ckYQ7vDBOlDz.png"></figure><ul><li style="text-align:justify;">Get deployment by Entity Id</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-YCOkrMCYMyRITEP3g4LdF4eKuUUDegAhIoEhxVfd.png"></figure><ul><li style="text-align:justify;">HTTP GET method.</li><li style="text-align:justify;">EntityId is required. In this topic, we manage documents by state base, that means document will have an id and entityId. </li><li style="text-align:justify;">After the document is updated, id will be generated new, entity id will not be changed, every document will have Latest property. </li><li style="text-align:justify;">The latest document will have Latest = true, and Latest = false for the rest. In this way, we can track the history change of the document.</li><li style="text-align:justify;">The query used to get document by entity id is:</li></ul>SELECT VALUE c FROM c      Where c.EntityId = @EntityId and c.Latest = true<ul><li style="text-align:justify;">Value of @EntityId is entityId param. </li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-h2VcJDPtdS6cPV4a0Pmy4Dn7ibo8roHtObwyyaGW.png"></figure><ul><li style="text-align:justify;">Update deployment</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-vO4AAZz2Ww3OrZSingNk1Ql246leXNNK4osOCVON.png"></figure><ul><li style="text-align:justify;">HTTP PUT method should be used when updating something.</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-Rc2uHlnFHSCcpUQ0sjqWcqkUvJwFnjiobiQzHGwQ.png"></figure><ul><li style="text-align:justify;">Insert deployment</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-4UwdnCs4j7ZmX2t6zV7xpH8nLcybikR9PXqZbgKx.png"></figure><ul><li style="text-align:justify;">HTTP POST method should be used when inserting something.</li><li style="text-align:justify;">System properties are not required</li></ul><figure class="image"><img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-gFXhysw5ZNb9DiwuJscbpO6M9sIc0mT4lv2geKnr.png"></figure></body></html>

This article provides a tutorial to create a basic API application with CosmosDb. The domain of this API application is deployment management. After this article, you will be able to create a CRUD RESTful API in .NET 6 and how to read, insert, delete, and update from Azure Cosmos Db using .NET 6 C#.

Basic API application with Azure Cosmos

Azure CosmosDb Series

<html><body><h2>    1. What is Azure Cosmos Db?</h2>Azure Cosmos Db is Microsoft's proprietary globally distributed, launched in May 2017.This is a Cloud-based database. That means your database is built, deployed, and delivered through a cloud platform.It is a NoSQL database. Your database could be stored in multi models-database, such as JSON documents store, Graph DBMS, Key-value store, and Wide column store, instead of columns and rows used by relational databases, such as SQL, Oracle, etc.With Azure Cosmos Db,  which is highly responsive and always online, we can build an application with low latency and high availability, and get the response data in milliseconds. <h2>    2. Why should we use it?</h2>Azure Cosmos Db support multi-model database. You can store data in multiple ways, by using different APIs:<figure class="table"><table class="ck-table-resized"><colgroup><col style="width:50%;"><col style="width:50%;"></colgroup><tbody><tr><td>API</td><td>Database</td></tr><tr><td>SQL API</td><td>JSON document database: non-relational database, store and query data as JSON documents</td></tr><tr><td>MongoDB API</td><td>MongoDB: A source-available cross-platform document-oriented database program</td></tr><tr><td>Cassandra API</td><td>Apache Cassandra: an open-source, NoSQL database, and designed to handle large amounts of data across many commodity servers with high availability and no single point of failure</td></tr><tr><td>Gremlin API</td><td>Graph database: Store data in graph structures, semantic queries with nodes, edges, and properties</td></tr><tr><td>Table API</td><td>Azure Table Storage: Store NoSQL database (non-relational structured data) in the cloud by using a schemaless design and a key/attribute store</td></tr></tbody></table></figure> Azure Cosmos Db will save your life from building a multi-center data environment. If you want to build a large-scale globally distributed application, a multi-center data environment should be required, which will take a lot of time, but Cosmos DB has already supported it and will help you skip those steps. You only have to configure it to replicate your data to all of your targeted regions. Low latency. With 60+ announced regions, you can easily place the data closer to the users, then they can have the minimum latency.Elastic Scale. Your cost is calculated by RU, which is calculated by 1 KB of data in 1 second. We can define max RU to manage throughput requirements and your money. When you set max RU = 1000 RU/s, if the throughput is over 1000 RU/s, an exception will be thrown. Cosmos DB starts rejecting the requests with 429 http status code then you can check your throughput, or update max RU in 2 ways: via the Azure portal or automatically via the Azure CLI.Support to create social media applications. (2)Social media applications need to store User Generated Content (UGC), such as text, images, videos, comments, posts, tweets, etc. UGC is unstructured data, it is a combination of free-form text, relationships, tags, etc. UGC required different and dynamic structures, that's why they cannot be stored in relational databases, which have fixed schema. But NoSQL database, schema-free, can do it. Easy to search content with Azure Cognitive Search - a cloud search service. Azure Cognitive Search provides APIs, and tools for building a search engine within a few minutes. Graph database with gremlin API is the best for sorting social media followers.Cost. 100 RU/s will cost £8.71 per month, a very cheap price for a global data center when compared with planning a multi-center data. So imagine that you have a global data center, and in order to support your applications smoothly, you have to spend plenty of money and time. That’s why we can say: 100 RU/s will cost £8.71 per month is too cheapOn the other hand, we can try CosmosDb for free.You can try this link to download: <a href="https://learn.microsoft.com/en-us/azure/cosmos-db/local-emulator?tabs=ssl-netstd21">Install and develop locally with Azure Cosmos DB Emulator | Microsoft Learn</a>Step by step instructions to install:You have to accept the license term<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-iLrMeBWk7UPHQlQjVX6NBkYA5gIHa6VNiUeXP8PZ.png">Install - Agreethen, installing<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-dAQlUQkDBRdEr9oxijvvNU2cMn6T55Edp2pbdYDl.png">Installingfinish<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-FLTDpZxKeJk5pfV0JmdKC4uBIMkg9CX2AHGI2glU.png">Install - FinishAfter installing, you can go to this Azure Cosmos Db Emulator shortcut to open the emulator<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-WM1s6O6igjkDbnknLMNJOrb4ZPQQi9YcPORX1dmb.png">Emulator - ShortcutAfter opening, you will get the notification at the corner of the screen<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-2wbr3FFehcbfB8ba6OIRwFib6KtmaC0YAx4IQFcw.png">Emulator - Startingand here is the notification when Azure Cosmos Emulator started<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-r45dNmJ4qj1UtWpMFSdnCnjJDTp9SiFyL4JNmThU.png">Emulator - StartedHere is the UI:<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-EID3us1hZbHBDLYQL0ka6rSMJ1fofoTyQvOAGZf4.png">UI - Web - UrlYes, we got the Web UI, with default URL is <a href="https://localhost:8081/_explorer/index.html">LOCAL-Azure Cosmos DB Emulator</a>In the web UI, we can try a sample at 1 <img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-QHLtZ0YAcKUUtkC2L3mBdG84t6E7tFevCLZkHsFU.png">UI - 1or learn more by reading document at 2<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-PYmvCcBdjoQ5YqXBsVQLASp4zF6aZMhOYU6Kolo7.png">UI - 2here is the explorer<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-SV06kpNem2Xu9jQNocVmFPysnKKCLQITxP9H6CVf.png">UI - Explorerthe query UI<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-KURmXJBAPdjFqIFXs0eUJAKt36jcT7azmHRyhAVr.png">UI - Querythe result<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-YIlDxbXuUJcZx7SrHVQkXGHrBRPzTHPIjyFEV2Dv.png">UI - Resultyou also have a minimap (code outline)<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-iWimMFQWqPw84CVHbYOvmEvjnzeYseFFoLaupOPe.png">UI - Minimap<h2>    3. Behind the scenes</h2>Case sensitive and only order by 1 column at default searchQuite expensive if we only have a small or medium systemThe migration of data from on-premises to cloud may take some timeBe careful when using partitioning. Every partition has to have PartitionKey. Microsoft guarantees that all the documents with the same PartitionKey are stored in the same Logical Partition. The maximum size of a logical partition (and consequently a physical partition) could not exceed 20 GB. We should choose the correct PartitionKey to make sure that every logical partition cannot exceed 20 GB.<h2 style="text-align:justify;">    4. When should we use it?</h2>Transactional volumes have many thousands of transactions per secondYou will get some challenges: concurrency, latency, and availabilityDistributed databases are the solution, but maintenance can still be a costly and time-consuming exercise.Azure CosmosDb will handle these challenges. It will be deployed worldwide across all Azure regions. Cloud-based will provide minimum latency and high availabilityDatabase contain many parent-child relationshipsIn this case, document-oriented databases are much better with object-oriented approaches, and Azure CosmosDb provides NoSQL document database.Your system is complex networks and relationshipsRelational databases present a less-than-optimal solution. Because relationships between entities do not actually exist in a relational database.Graph database engines could be considered a re-emergence of the network database paradigm, and Azure CosmosDb has Azure CosmosDb for Gremlin.When you want to build social media applications<h2>    5. Azure Cosmos Database vs SQL Server</h2><figure class="table"><table class="ck-table-resized"><colgroup><col style="width:33.33%;"><col style="width:33.33%;"><col style="width:33.34%;"></colgroup><tbody><tr><td> </td><td>Azure Cosmos Database</td><td>SQL Server</td></tr><tr><td>Type</td><td>NoSQL database</td><td>Relational database</td></tr><tr><td>Cloud-based</td><td>Yes</td><td>No</td></tr><tr><td>Server Operating Systems</td><td>Hosted</td><td>LinuxWindows</td></tr><tr><td>Data Scheme</td><td>Schema-free</td><td>yes</td></tr><tr><td>Query Language</td><td>SQL-like</td><td>SQL</td></tr><tr><td>APIs</td><td>DocumentDB APIGraph API (Gremlin)MongoDB APIRESTful HTTP APITable API</td><td>ADO.NETJDBCODBCOLE DBTabular Data Stream (TDS)</td></tr><tr><td>Supported Programming Languages</td><td>.NetC#JavaJavaScriptJavaScript (Node.js)MongoDB Python</td><td>C#C++DelphiGoJavaJavaScript (Node.js)PHPPythonRRubyVisual Basic</td></tr><tr><td>Scalability Methods</td><td>Scale-out: add more components in parallel to improve performance</td><td>Scale-up: update component to bigger, faster to improve performance</td></tr><tr><td>Database sharding</td><td>Automatically</td><td>Manually</td></tr><tr><td>Hierarchical data(1)</td><td>Document-oriented</td><td>Object-oriented</td></tr></tbody></table></figure> (1):<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-RfeTYop4Z8iWaWCYkDZJjX8oBRaP499biJkLqejt.png">Hierarchical Data- Relation and CosmosDb     Price<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-jb0fgq72CdcX1VNwZ5FW16Z1AVRwW1gphcsZgelP.png">Price-CosmosAzure CosmosDb Price with Region = East US and currency = USD<img src="https://api.careers.saigontechnology.com/storage/ck-editor/CKEDITOR-pCBddGwCLk924Bplh4GX5AWy1j6DwmbN6agYeM2f.png">Price-SQL</body></html>

This article provides an overview of the Azure Cosmos DB. Cloud-based NoSQL database, highly responsive, high availability, always online, low latency, multi-model database for managing data at large scales.

Basic API application with Azure Cosmos

Related articles

OTHER ARTICLES FROM STEVEN PHAM