Fundamentals

How it works

The above scheme shows the general internal structure of the library and the main principles of its work. EasyQuery components All EasyQuery classes and components can be divided into two main parts: logical part (DataModel, Query, SqlQueryBuilder). the visual part (QueryPanel, ColumnsPanel, etc.). The logical part is responsible for the internal representation of data structures and user

Working with table aliases

In this article, we provide all the information needed to use aliases properly. There is an explanation, what for aliases are in the DME and an example of using it.

Working with several data models

All EasyQuery demos works with one data model (and one database which corresponds to that model). Here we are going to describe how to add a selector that switches between two data models on your view/page and then how to setup a custom "model loader" to handle GetModel requests propertly. To make it possible to switch between these two models we need some selector element on our page. The only problem here - is to switch the database connection accordingly the the switches between the models. Now when the user selects an item in our model selector element on the client-side - our server-side code automatically loads the selected model and connects to a proper database (when necessary)..

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.

Connect to your database

This article describes how to modify our sample project to make it work with your own database instead of Northwind DB used by default.

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

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

Getting started for ASP.NET 4

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

Tables and links page

Learn how to work with tables and links within your Data Model, change and edit them.

Upgrading from version 3.x to 4.0

How to upgrade your project from version 3.x to version 4.0 of EasyQuery

Version 5.3 + EasyQuery.JS 6.0 release notes

The biggest change in this release is a new major update (version 6.0) of JavaScript library (EasyQuery.JS) used with ASP.NET or ASP.NET Core editions of EasyQuery. Version 5.3 of EasyQuery contains rather small improvements in the core libraries and all .NET editions. Community edition packages include @easyquery/core , @easyquery/ui . All license owners of EasyQuery for ASP.NET or EasyQuery for ASP.NET Core automatically got a license for EasyQuery.JS as well. to set your key, now for ASP.NET Core edition it will be Respectively, you should use Korzh.EasyQuery.AspNet...

Version 3.7.0 release notes

Version 3.7.0 release notes

EasyQuery License key

Here we describe how to apply the product key that you get after purchasing the license and which allows you to unlock all the features of EasyQuery library.

Paging in query results

Paging can make your work with query more convenient. And here is detailed instruction on how to use it.

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

Getting started for ASP.NET WebForms

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

Version 3.6.0 release notes

Version 3.6.0 release notes

Version 4.4.2 release notes

1. Core library UseParameters options in EqServiceProvider class. Now you don't need to define your own QueryBulider handler. Just set eqService.UseParameters = true and all SQL statements will be generated with parameters. Add parameter processing for the special date/time values (like this month , previous year , etc). Fixed: parameters didn't work in sub-queries

Upgrading from version 4.x to 5.x

Here you will find step-by-step instructions on how to upgrade your current ASP.NET Core project that uses version 4.x of EasyQuery to version 5.0

User-friendly name for tables

Some tips for choosing right “entities” and their “attributes”