Tutorials

Previous versions' tutorials (obsolete)

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

Adding columns and conditions with code

Example of code for adding columns and conditions

Build query by code on the client-side

Here you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.

Create a query with sub-query by code

Example with code

Copying the EasyQuery's code from a sample to your project

If you have already modified one of our sample projects to make it work with your DB, the next step will be to copy the EasyQuery's code to your own solution. This article describes how to do it.

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.

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

Here you can find all steps you need to perform

EqExpression class

Represents common expression object.

EqExpression class

Represents common expression object.

Building dynamic queries with EasyQuery and Entity Framework

Here we describe how EasyQuery helps to implement a query building UI for creating custom, dynamic queries in .NET projects which use Entity Framework (6.x)

Adhoc reporting page in your web application

This article describes how to implement the adhoc reporting functionality (similar to the one from our live demos) in your own project.

Version 5.1 release notes

Version 5.1 is a minor update to version 5.0 which fixes several small bugs and brings few new classes to support authentication/authorization procedures for EasyQuery middleware actions. Core library 1. IEqAuthProvider interface Version 5.1 introduces IEqAuthProvider interface which defines the structure of the authentication provider class

Gridview filtering with EasyQuery ASP.NET (WebForms)

Gridview filtering with EasyQuery ASP.NET (WebForms)

Date/time values formatting

In this article, you can find instructions how to set up different types of date & time formats, with code examples.

Version 3.5.0 release notes

Version 3.5.0 release notes

DbExprTag class

Contains several constants for db-related expressions tags values

DbExprTag class

Contains several constants for db-related expressions tags values

Upgrading to 5.x: ASP.NET (MVC and WebForms) projects

This tutorial describes how to upgrde your old ASP.NET MVC project with EasyQuery 3.x to EasyQuery version 5.2.0 (or higher). 1.2 Use NuGet Package Manager to install the following packages: Korzh.EasyQuery.AspNet4 Korzh.EasyQuery.EntityFramewok6 - if you are using Entity Framework 6.x Korzh.EasyQuery.DataExport - if you will need the data exporting functions Korzh.EasyQuery.MsSqlGate (or .MySqlGate or .OdbcGate depending on your DB) - if you need to load your model directly from DB connection. Finally, we need to make some modifications on our pages where we use EasyQuery scripts. Version 5.2.0 and higher of EasyQuery scripts will not need JQuery anymore, so you will be able to throw them away if they are not used in your own pages. Here is an example for "advanced search" view: To update your Web Forms page your will need to do the following 3 steps: Add EasyQuery scripts and styles on your page.

ExprTag class

Contains several constant definitions for expressions tag