Tutorials

Previous versions' tutorials (obsolete)

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

Entity class

Represents one entity

Entity class

Represents one entity

Entity class

Represents one entity

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)

Entities page

This page describes entities participating in the data model and their attributes.

Hide some entities and/or attributes

Here we explain how to implement different ways to limit the quantity of entities and attributes shown in Data Model

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

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 .

Navigate through data model entities and attributes

A code snippet which demonstrates how to run through data model entities and attributes

MetaEntity class

Represents one entity

EntityXmlSerializer class

EntityStore class

DataModel class

Represents a data model

DataModel class

Represents a data model

EntityStore class

Represents storage of entities

DbModel class

Database-related implementation of [Korzh.EasyQuery.DataModel](api-reference-4x/korzh-easyquery-namespace/datamodel-class) class. In addition to the basic data it contains also list of database tables and the links between them.

DbModel class

Database-related implementation of [Korzh.EasyQuery.DataModel](api-reference-5x/korzh-easyquery-namespace/datamodel-class) class. In addition to the basic data it contains also list of database tables and the links between them.

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.