Tutorials

Simple query over one table

How to build a simple query with 1-2 conditions over one table (entity)

Previous versions' tutorials (obsolete)

This section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.

Query with table joins

An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

Table class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-4x/korzh-easyquery-db-namespace/dbmodel-class) object

Table class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-5x/korzh-easyquery-db-namespace/dbmodel-class) object

Table class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbmodel-class) object

Query with OR operators

In this article, you will learn how to build queries that contain both AND and OR operators.

Query with a subquery

How to build queries with subqueries using EasyQuery.

Tables and links page

Learn how to work with tables and links within your Data Model, change and edit them.

Working with table aliases

In this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.

Create a query with sub-query by code

Example with code

Common SQL queries

Query.Error class

Query exception class.

Query class

Represents internal query structure.

Store queries in a database

Here we describe the case when all users of some web application create their own queries and would like to store those queries in some database.

Query class

Represents internal query structure.

Paging in query results

Paging can make your work with query more convenient. And here is detailed instruction on how to use it.

Generating queries for 2 (or more) databases

Here you can find tricks for executing this task

User-friendly name for tables

Some tips for choosing right “entities” and their “attributes”