Chapter 4. Advanced Querying
This chapter will guide you through more advanced querying techniques. We will also focus on using built-in functions and creating triggers, stored procedures, and working with transactions. Finally, we will also create user-defined functions and demonstrate how to apply them in advanced queries.
Each section will discuss different querying techniques, showing both the DocumentDB SQL statements as well as the output.
In this chapter, we will cover the following topics:
- Learn about the
SELECT
,FROM
, andWHERE
statements in detail - Learn how to apply operators in your queries
- Demonstrate how to use built-in functions
- Outline how to build stored procedures, triggers, and user-defined functions
- Discuss using LINQ to DocumentDB
- Learn how to work with transactions
At the time of writing, DocumentDB does not support aggregate functions like SUM
or COUNT
. Also, no GROUP BY
is supported yet.