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.

ASP.NET Core tutorials

This section contains all getting started articles for the version 5.x branch of EasyQuery for .NET Core. Please note if you have a project for .NET Framework (version 4.x or earlier) - please look at the articles in [$$-Version 3.x-$$](/$aid/eqdn-6f1z3hf0ml4u) section.

Getting started for EasyQuery ASP.NET MVC

This article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application

Getting started for ASP.NET WebForms

Here you can find the instructions how to add EasyQuery components into your ASP.NET WebForms project

Gridview filtering with EasyQuery ASP.NET (WebForms)

Gridview filtering with EasyQuery ASP.NET (WebForms)

Getting started for ASP.NET 4

Describes the steps you need to perform for applying EasyQuery ASP.NET to your MVC or WebForms project

Getting started for ASP.NET Core + MVC or Razor pages

How to use install EasyQuery to your ASP.NET Core project with Razor Pages or MVC.

Getting started for EasyQuery ASP.NET Core (version 4.x)

Describes how to setup EasyQuery in ASP.NET Core web application

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 .

Getting started for ASP.NET Core + Vue project

How to use EasyQuery library in Vue.js project with ASP.NET Core backend.

Getting started with EasyQuery in ASP.NET Core + Angular project

How to add ad-hoc reporting or data-filtering functionality to your ASP.NET Core project with Angular frontend.

Getting started for ASP.NET Core + React project

How to use EasyQuery library in React.js project with ASP.NET Core backend.

Upgrade instructions. From Version 3.x to 5.x for .NET Framework 4.x projects

EasyQuery.NET 5.4.1 + EasyQuery.JS 6.1.0 release notes

Better performance It takes less time and memory for the new grid to render the same amount of data. It's easier now to define the styles for different parts of the grid and to set custom styles for each column or even for a particular cell. The code of our new grid was moved to a separate NPM package ( @easydata/ui ) and so, can be used even without EasyQuery at all. This new widget allows us to define different views for your result set. As already said, our server-side API code (EasyQuery middleware for .NET Core and WebAPI controller for .NET 4.x) was updated to support the new data format and other changes in EasyQuery.JS 6.1.0 Version 5.4.1 also includes a possibility to save/load queries to/from the files on the visitor's computer.

Upgrade instructions: EasyQuery.NET 5.3 + EasyQuery.JS 6.0

If you use EasyQuery.JS via NPM packages (for example, in your Angular or React project) you need to do the following changes: Since JQuery is not used anyore, you can remove @easyquery/ui-jquery package from your project. All functionality from this package was moved either to @easyquery/core or @easyquery/enterprise packages. Add @easyquery/enterprise package if you need full set of features as in previous version (5.1.x) of EasyQuery. Obviously, set the version number for all EasyQuery packages to 6.0.0 (or higher). Get the license key for EasyQuery Enterprise.

JavaScript widgets formats and settings (MVC version)

In this article, we describe the most common unique settings for EasyQuery JavaScript widgets and give examples of code.

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

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.

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.

Working with data models in EasyQuery

This article will guide you through all issues about working with data models in EasyQuery library. How to load it from the DbContext or from your DB connection, or now to create a new one using Data Model Editor.