In this chapter, we discussed advanced querying options for our databases in great detail. First, we saw how to use the SELECT
statement together with the FROM
statement. We saw how to use JOIN
operations and how to select from so-called subdocuments. Next, we discussed how to use the WHERE
statement along with different operators such as BETWEEN
, AND
, and IN
, and how to use conditional expressions.
In subsequent sections, we discussed how to use built-in functions. We saw how to write our own stored procedures, triggers, and user-defined functions. Finally, we talked about the LINQ provider for DocumentDB.
In the next chapter, you will learn about the REST protocol and how to use it to access DocumentDB resources. This will be demonstrated in C# snippets and by the use of an external tool called Fiddler.