In this chapter, we learned the necessary steps for composing and executing queries against a Cosmos DB collection that uses the SQL API. Now we are able to select the most appropriate tool based on our specific needs.
We understood query results for the Cosmos DB SQL dialect. We learned that the results are JSON arrays. We used the different tools to check the resource units that Cosmos DB charges for each query and we understood its impact on the available resource units after a query is executed.
We worked with schema-agnostic queries and we used many built-in functions, including type-checking and array functions. We worked with joins, array iterations, projections, and aggregate functions. We understood how to take advantage of the Cosmos DB SQL dialect to work with a schema-agnostic document database.
Now that we have a very clear understanding of the document database and its SQL dialect, we will use the .NET Core SDK and C# to code and tune our first Cosmos DB application, which...