Tutorials

Getting Started

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)

Dynamic PHP query builder with EasyQuery

Dynamic PHP query builder with EasyQuery

Previous versions' tutorials (obsolete)

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

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 .

Entity class

Represents one entity

Getting started for WPF

You will be able to apply EasyQuery WPF to your application, performing all the instructions in this article

Getting started for Silverlight

This article will guide you through all steps necessary to apply EasyQuery.NET to your application, with extract examples

Entity class

Represents one entity

Entity class

Represents one entity

Getting started for WPF

Getting started tutorial on how to use EasyQuery components to implement an ad-hoc query builder in WPF application.

Entities page

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

Dynamically populate lists by information from other conditions — WebForms

A code snippet which demonstrates how to execute this task

Building data model dynamically by DB meta-information

It's easier to fill your model right in the code directly from your database, using meta-information

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.

Creating data model dynamically with code

-Data Model- object is an essential part of EasyQuery framework. However, sometimes you need to add some entities, entity attributes or operators to the existing model or to fill it from scratch using DB metadata information got from another source. In these cases, you can use EasyQuery API to build the model dynamically. Finally, we add entities and entity attributes. Here is an example of creatin a small data model: two tables (Customers and Orders) with one link between them, 2 entities (Customer and Order correpondingly) and a few attributes in each entity.

Building data model dynamically by information from a DataTable

Example of how to build data model by certain information from DataTable

Getting started for Windows Forms

This article shows how to apply EasyQuery.NET to your application

Query with a subquery

How to build queries with subqueries using EasyQuery.