Tutorials

From a sample to your own project

[EasyQuery GitHub repositories](https://github.com/easyquery) contain several sample projects that demonstrate how to use EasyQuery library on different platforms, with differen frameworks and in different scenarios. The best way to start with EasyQuery is to choose the sample closest to your scenario and modify it according to your requirements (your DB, data model, environment, layout, styles, etc). So, in this section we are going to describe how to do it.

Previous versions' tutorials (obsolete)

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

Using EqMvcDemoEF sample with your own DB context

This article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class

Query with OR operators

In this article, you will learn how to build queries that contain both AND and OR operators.

Query with a subquery

How to build queries with subqueries using EasyQuery.

Copying the EasyQuery's code from a sample to your project

If you have already modified one of our sample projects to make it work with your DB, the next step will be to copy the EasyQuery's code to your own solution. This article describes how to do it.

Create a query with sub-query by code

Example with code

Common SQL queries

Query.Error class

Query exception class.

Query class

Represents internal query structure.

Using MS SQL instead of Access in WebDemo sample project

In this article, you will find the detailed instructions how to modify WebDemoCS or WebDemoAjaxCS to make it work with SQL Server instead of Access

Query with table joins

An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

Store queries in a database

Here we describe the case when all users of some web application create their own queries and would like to store those queries in some database.

Query class

Represents internal query structure.

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.

Paging in query results

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

Simple query over one table

How to build a simple query with 1-2 conditions over one table (entity)

Generating queries for 2 (or more) databases

Here you can find tricks for executing this task

Navigate through query conditions

A code snippet which demonstrates how to run through all conditions in your query