Fundamentals

How to make a field to field comparison

The instructions on how to add a condition which compares a field against another field instead of constant value.

Lookup fields and columns

How to deal with lookup fields in EasyQuery

Entities page

This page describes entities participating in the data model and their attributes.

EqExpression class

Represents common expression object.

EqExpression class

Represents common expression object.

DbFieldInfo class

Represents a structure that contains information about some table field

DbExprTag class

Contains several constants for db-related expressions tags values

LinkCondType enum

Represents the type of linking condition (field-to-field, field-to-expression, etc.)

LinkCondType enum

Represents the type of linking condition (field-to-field, field-to-expression, etc.)

LinkCondType enum

Represents the type of linking condition (field-to-field, field-to-expression, etc.)

DbExprTag class

Contains several constants for db-related expressions tags values

ExprTag class

Contains several constant definitions for expressions tag

How to show descriptive texts in some column instead of numeric values

How to show some descriptive texts for some column in result set instead of actual numeric values stored in DB

DbFieldInfo class

Represents a structure that contains information about some table field

DbFieldInfo class

Represents a structure that contains information about some table field

ExprTag class

Contains several constant definitions for expressions tag

Terminology

Common 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'")

EqExpression class

Represents common expression object.

Data Model

In 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: