Learning > ECSQLtutorial Edit this page Learning ECSQL This tutorial allows you to learn how to use ECSQL to read and query the business data in your iModels. ECSQL is an implementation of SQL — a proven, well-adopted text-based command language. It adheres to standard SQL (SQL-92 and SQL-99) wherever possible. Prerequisites SQL In the course of the tutorial you will notice how similar ECSQL and SQL are. To not reinvent the wheel, this tutorial therefore expects you to be familiar with the basics of SQL. If you are new to SQL, please take a class on the SQL basics first. iModelConsole The tutorial makes reference to the iModelConsole application. Use the app to follow along with the tutorial by executing the ECSQL examples yourself. You can also experiment with your own ECSQL statements. Open the iModelConsole Sample iModel The ECSQL examples in the tutorial work with the "House Sample" iModel. You can explore the imodels here. BIS The schemas for iModels are based on BIS. Therefore, the examples throughout the tutorial use the BIS schemas. While not required to learn ECSQL, familiarity with BIS is a good idea to get more from this tutorial. Scope The data in iModels can only be modified via the respective APIs. ECSQL is used to query the data from iModels. Therefore the tutorial only covers the query portion of ECSQL, i.e. ECSQL SELECT statements. How to use the tutorial The tutorial looks at typical questions and finds the respective ECSQL answer to it. The goal of the tutorial is that you can try out all ECSQL statements used in the lessons yourself. The tool to run the ECSQL statements is the iModelConsole with the tutorial's Sample iModel. This also enables you to experiment more with ECSQL by modifying the tutorial's ECSQL statements or by trying out your own ECSQL statements. Step 1 - Start the iModelConsole If you want to follow along with your own iModel: Launch the console at https://imodelconsole.bentley.com Authenticate with your iTwin credentials. Open your iModel by clicking on the iModels in the table Step 2 - Open the sample iModel For this ECSQL tutorial, the embedded console will attach to the sample iModel we provide. Step 3 - Run an ECSQL in the iModelConsole Once you have opened your iModel, just type in the ECSQL and hit Enter to execute it. Or simply use the provided sample below: Try it yourself ECSQL SELECT * FROM bis.Element Tutorial Overview Lesson 1: Key to ECSQL Lesson 2: The first examples Lesson 3: ECSQL Data Types Lesson 4: Relationships and Joins Lesson 5: Class Polymorphism Lesson 6: Spatial Queries Lesson 7: Meta Queries - Querying ECSchemas Lesson 8: Querying Change Summaries Lesson 9: Class Filter Lesson 10: Conditional Expressions Lesson 11: Built-In functions Next > Last Updated: 02 February, 2022