Tutorials

Previous versions' tutorials (obsolete)

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

Operator class

Represents a logical expression or predicate, like comparisions or LIKE predicate.

Operator class

Represents a logical expression or "predicate". For example: "less than", "is equal to", "starts with".

Operator class

Represents a logical expression or "predicate". For example: "less than", "is equal to", "starts with".

Query with OR operators

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

Operators page

This article defines operators which can be used in conditions (such as 'is equal to', 'less than' and others).

Add a new aggregate function

EasyQuery allows to add new aggregate functions for user's need. Here is detailed manual of how to do it with code example.

Adding a new operator to your data model

Here you can find all information about how to add a new operator to your data model either using Data Model Editor (DME) or with a code

How to add an extra condition to your query

Two possible ways of resolving this task

How to add a column with the same attribute as in newly added condition

A code snippet which demonstrates how to do this task

Custom client-side dialogs

Users who use some other dialogs libary usually want to replace those default dialogs with their own. We are going to replace those default dialogs with nice HTML dialogs made with JQuery UI dialogs library. The approach we will use is quite simple: our AdvancedSearchView JavaScript class has several methods which can be "overriden" to replace the default behavior with your own implemenation of those dialogs. In case of using JQuery dialogs we need to define some placeholders (read div elements) on our page where our new dialogs will be rendered. Here is an example: NB: Please note that this step is specific for JQuery dialogs.

Add query builder page from our MVC sample project in your own app

This article described how to set up an advanced search page in your web-application using EqMvcDemoDB project as a template.

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.

Changelog

Contains the full list of all changes in the EasyQuery packages.

Building data model dynamically using code (version 3.x)

Here you can find all steps you need to perform

DataModel class

Represents a data model

DataModel class

Represents a data model

DataModel class

Represents a data model

Creating data model dynamically with code

-Data Model- object is an essential part of EasyQuery framework. However, sometimes you need to add some entities, entity attributes or operators to the existing model or to fill it from scratch using DB metadata information got from another source. In these cases, you can use EasyQuery API to build the model dynamically. Finally, we add entities and entity attributes. Here is an example of creatin a small data model: two tables (Customers and Orders) with one link between them, 2 entities (Customer and Order correpondingly) and a few attributes in each entity.