Tutorials

Previous versions' tutorials (obsolete)

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

Setting anti-forgery token for AJAX requests from EasyQuery widgets

Here you can find out how to strengthen security of your project using antiForgeryToken option.

EasyQueryApiHandler class

This class contains the handlers for all kind of HTTP requests to EasyQuery API (like GetModel, GetQuery, etc).

EasyQueryApiController class

The base WebAPI controller for all other EasyQuery controllers implementations. Implements the `System.Web.Http.ApiController`

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.

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.

EqExpression class

Represents common expression object.

Dynamic queries for ASP.NET Core projects with Entity Framework Core

It takes a few minutes to add a new page with all necessary UI for building dynamic queries and to setup a middleware that will process all requests from that page, convert those request to the queries to your DB and return the result set back for visualization. This step is necessary to get the trial keys for EasyQuery framework. One for ASP.NET Core packages and another one - for EasyQuery.JS scripts. To simplify this task EasyQuery includes a Razor UI library package ( Korzh.EasyQuery.RazorUI ) that contains several predefined pages which you can use in your projects. For example, there is an "advaced search" page which is available via /EasyQuery/AdvancedSearch .

EasyQueryOptions class

Contains various options used in EasyQueryMiddleware, EasyQueryManager and other classes.

EasyQueryOptions class

Contains various options used in EasyQueryMiddleware, EasyQueryManager and other classes.

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

EasyQueryManager class

Provides basic functionality for managing different EasyQuery operations and to process the AJAX requests from EasyQuery JavaScript widgets. This class is abstract and it implements only the most common features. The descendants of this class provides more concrete implementation of the model loading and query generation

DbExprTag class

Contains several constants for db-related expressions tags values

EasyQuery ASP.NET - using jQuery widgets on WebForms project

In this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples

DbExprTag class

Contains several constants for db-related expressions tags values

ExprTag class

Contains several constant definitions for expressions tag

ExprTag class

Contains several constant definitions for expressions tag