How to make a field to field comparison
/how-to/field-to-field-comparisonThe instructions on how to add a condition which compares a field against another field instead of constant value.
Lookup fields and columns
/tutorials/lookup-fields-columnsHow to deal with lookup fields in EasyQuery
Entities page
/data-model-editor/entities-pageThis page describes entities participating in the data model and their attributes.
DbFieldInfo class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbfieldinfo-classRepresents a structure that contains information about some table field
LinkCondType enum
/api-reference-4x/korzh-easyquery-db-namespace/linkcondtype-enumRepresents the type of linking condition (field-to-field, field-to-expression, etc.)
LinkCondType enum
/api-reference-5x/korzh-easyquery-db-namespace/linkcondtype-enumRepresents the type of linking condition (field-to-field, field-to-expression, etc.)
LinkCondType enum
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/linkcondtype-enumRepresents the type of linking condition (field-to-field, field-to-expression, etc.)
DbFieldInfo class
/api-reference-4x/korzh-easyquery-db-namespace/dbfieldinfo-classRepresents a structure that contains information about some table field
DbFieldInfo class
/api-reference-5x/korzh-easyquery-db-namespace/dbfieldinfo-classRepresents a structure that contains information about some table field
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
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:
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
How to show descriptive texts in some column instead of numeric values
/how-to/descriptive-texts-in-column-instead-numeric-valuesHow to show some descriptive texts for some column in result set instead of actual numeric values stored in DB
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.
DbGate class
/api-reference-4x/korzh-easyquery-db-namespace/dbgate-classRepresents base class which allows to get DB structure information availble for some connection
EqExpression class
/api-reference-4x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
DbGate class
/api-reference-5x/korzh-easyquery-db-namespace/dbgate-classRepresents base class which allows to get DB structure information availble for some connection
Terminology
/fundamentals/terminologyCommon terms Database - may refer to any data storage but in most cases we mean some relational database such as MS SQL Server, My SQL, Oracle, etc. Result set - a result of some search request (query). Usually, is presented as tabular data. Query - a search request. Query condition - one of the search terms (for example: "Customer name starts with 'A'")
OrderByStyles enum
/api-reference-5x/korzh-easyquery-namespace/orderbystyles-enumRepresents the way fields appear in ORDER BY clause
OrderByStyles enum
/api-reference-4x/korzh-easyquery-namespace/orderbystyles-enumRepresents the way fields appear in ORDER BY clause