How to save/load queries to/from database

Find out how to change this default behavior and save/load queries to any other storage

Query saving and loading

EasyQuery has built-in means for query saving and loading. Here we are going to describe the most common approaches for solving this task

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.

Generating queries for 2 (or more) databases

Here you can find tricks for executing this task

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.

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.

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.

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.

Query class

Represents internal query structure.

Paging in query results

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

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.

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.

Simple query over one table

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

Custom client-side dialogs

Users who use some other dialogs libary usually want to replace those default dialogs with their own. We are going to replace those default dialogs with nice HTML dialogs made with JQuery UI dialogs library. The approach we will use is quite simple: our AdvancedSearchView JavaScript class has several methods which can be "overriden" to replace the default behavior with your own implemenation of those dialogs. In case of using JQuery dialogs we need to define some placeholders (read div elements) on our page where our new dialogs will be rendered. Here is an example: NB: Please note that this step is specific for JQuery dialogs.

Navigate through query conditions

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

Using parameters in query conditions

This article explains how to work with parameterized conditions.