Tutorials

Common SQL queries

Customizing common SQL clauses

This article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)

Previous versions' tutorials (obsolete)

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

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.

Customizing SQL query formats

Detailed instruction with various examples of how to operate with different query formats.

Create a query with sub-query by code

Example with code

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.

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.

Simple query over one table

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

Paging in query results

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

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

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

Using parameters in query conditions

This article explains how to work with parameterized conditions.