Querying Data in MYOB Acumatica Framework

In MYOB Acumatica Framework, you generally use business query language (BQL) to query data from the database. BQL statements represent specific SQL queries and are translated into SQL by MYOB Acumatica Framework, which helps you to avoid the specifics of the database provider and validate the queries at the time of compilation. MYOB Acumatica Framework provides two dialects of BQL: traditional BQL and fluent BQL.

To query data from the database, you can also use language-integrated query (LINQ), which is a part of the .NET Framework. In the code of MYOB Acumatica Framework-based applications, you can use both the standard query operators (provided by LINQ libraries) and the MYOB Acumatica Framework-specific operators that are designed to query database data.

This chapter explains the aspects that are common to traditional BQL, fluent BQL, and LINQ and provides a high-level comparison of the approaches for querying data in MYOB Acumatica Framework.