Tables and links page
/data-model-editor/tables-links-pageLearn how to work with tables and links within your Data Model, change and edit them.
About Data Model Editor
/data-model-editor/aboutHere you can find detailed information about this instrument and guideline, how to use it to perform all needed tasks.
Pages class
/api-reference-5x/korzh-easyquery-razorui-namespace/pages-classContains the settings for the default pages from EasyQuery Razor UI library
Pages class
/api-reference/korzh-easyquery-razorui/korzh-easyquery-razorui-namespace/pages-classContains the settings for the default pages from EasyQuery Razor UI library
Data Model
/fundamentals/data-modelIn short (and by its name), data model - is a model (representation) of some data stored in your database. It solves two major problems: Presents the data to the end user in a more friendly and familiar way. Contains some meta information that helps EasyQuery components to build query statements in SQL or other query languages. Any data model contains the following main sections:
Entities page
/data-model-editor/entities-pageThis page describes entities participating in the data model and their attributes.
Value Editors
/data-model-editor/value-editorsHere you can find the full list of editors and choose any you need in your work with Data Model:
Operators page
/data-model-editor/operators-pageThis article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).
Table class
/api-reference-4x/korzh-easyquery-db-namespace/table-classTable class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-4x/korzh-easyquery-db-namespace/dbmodel-class) object
Table class
/api-reference-5x/korzh-easyquery-db-namespace/table-classTable class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-5x/korzh-easyquery-db-namespace/dbmodel-class) object
Table class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/table-classTable class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbmodel-class) object
Paging in query results
/tutorials/paging-in-query-resultsPaging can make your work with query more convenient. And here is detailed instruction on how to use it.
Edit link dialog
/data-model-editor/edit-link-dialogHere you can find all necessary information of how to edit link dialog and how to add new conditions.
Aggregate data
/tutorials/aggregate-dataFrom this article you will see how to aggregate (count, sum, etc.) data in your queries.
Working with several data models
/tutorials/several-data-modelsAll EasyQuery demos works with one data model (and one database which corresponds to that model). Here we are going to describe how to add a selector that switches between two data models on your view/page and then how to setup a custom "model loader" to handle GetModel requests propertly. To make it possible to switch between these two models we need some selector element on our page. The only problem here - is to switch the database connection accordingly the the switches between the models. Now when the user selects an item in our model selector element on the client-side - our server-side code automatically loads the selected model and connects to a proper database (when necessary)..
Query with table joins
/tutorials/query-with-table-joinsAn example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.
Working with table aliases
/data-model-editor/working-with-aliasesIn 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.
Possible ways of data model creation and loading
/tutorials/data-model-creation-loadingEasyQuery components need a [data model](/$aid/03bc06b0-83ec-4040-97ef-a50ca004177f) (a user-friendly representation of your DB) for their work. There are several different ways to create the model and load it on your project's startup. This article will describe all of them in detail.
Navigate through data model entities and attributes
/how-to/run-through-data-model-entitiesA code snippet which demonstrates how to run through data model entities and attributes