Tutorials

Previous versions' tutorials (obsolete)

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

Version 3.x (obsolete)

Contains the "getting started" articles for version 3.x branch of EasyQuery. This section includes the tutorials for Windows Forms, WPF, WebForms and old ASP.NET MVC (not Core) editions of the library.

Version 4.x (obsolete)

Getting started articles for the old version (4.x) of EasyQuery for .NET Core

API reference 4.x (obsolete)

API reference 5.x (obsolete)

Obsolete (for version 3.x or lower)

This section contains the tutorials for previous versions of EasyQuery.

Localization of EasyQuery widgets (obsolete)

This article shows how to localize widgets, with extract examples

Processing custom value editors in EasyQuery JS

Here you can find tips how to value editor setup and how to value editor widget

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.

EqExpression class

Represents common expression object.

EqExpression class

Represents common expression object.

Version 5.2 release notes

Version 5.2 of EasyQuery not only brings some improvements to the .NET Core edition, it;s also the first release of 5.x branch for all other editions of EasyQuery which uses on .NET Framework 4.x and still were on 3.x branch until now: WinForms, WPF and ASP.NET 4 editions. There are 2 big changes in ASP.NET edition of EasyQuery which affects your MVC project when you upgrade to EasyQuery version 5.2.0 or higher. Starting from version 5.2.0 EasyQuery for ASP.NET uses the latest version of the client-side library (EasyQuery.JS 5.1.8 for now) which is the same that is used in ASP.NET Core edition. The same as for MVC applications, for WebForms we now use the latest version of EasyQuery.JS library on the client-side and a WebAPI controller on the server-side. Bug fixed: Disabled columns were included into GROUP BY section Bug fixed in WPF edition: Empty column title on edit Bug fixed in WPF edition: Wrong behavior of "Duplicate condition" operation If you are upgrading from version 5.x for ASP.NET Core - you just need to change the version numbers of all EasyQuery NuGet packages you are using to 5.2.0 and the version of the EasyQuery script files (or NPM packages) to 5.1.8 NB : For the users of EasyQuery script bundles (like eq.all.min.js ) published on our CDN You will also need to modify the full path to the EasyQuery classes and add ui namespace to it.

Date/time values formatting

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

Upgrade instructions: Version 7.0

You just need to update the version of all EasyQuery packages (except Korzh.EasyQuery.MsSqlGate - see the details below) to 7.0.x (whatever the latest version is there at the time of your reading). For example: should be changed to: As for Korzh.EasyQuery.MsSqlGate package, it was renamed to Korzh.EasyQuery.SqlServerGate (to prevent any confusion with Korzh.EasyQuery.MySqlGate ). Here are examples: Before EasyQuery 7.0: EasyQuery 7.0+ Both functions accepts a delegate with EasyQueryOptions parameter, so no changes here. Here are some examples: In the most cases, your client-side code and markup will not need a lot of changes with version 7.0 of EasyQuery.JS. Here are the thins that require your attention: If the license key for EasyQuery.JS is hardcoded in the page's script as a parameter of useEnterprise(...) call (like view.getContext().useEnterprise('YourEasyQueryJsKeyGoesHere') ) you will need to get a new one for version 7.0 and replace it there.

DbExprTag class

Contains several constants for db-related expressions tags values

DbExprTag class

Contains several constants for db-related expressions tags values

ExprTag class

Contains several constant definitions for expressions tag

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