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.

API reference

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.

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

API reference 4.x (obsolete)

API reference 5.x (obsolete)

Adding columns and conditions with code

Example of code for adding columns and conditions

API reference (previous versions)

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

Build query by code on the client-side

Here you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.

Create a query with sub-query by code

Example with code

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.

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.

Building data model dynamically using code (version 3.x)

Here you can find all steps you need to perform

Query class

Represents internal query structure.

DataModel class

Represents a data model

Condition class

Represents one condition in the query.

MetaData class

Read-only constant that represent the latest format version of data model definition JSON files

DataModelXmlSerializer class

EasyQueryManager class

Provides basic functionality for managing different EasyQuery operations and to process the AJAX requests from EasyQuery JavaScript widgets. This class is abstract and it implements only the most common features. The descendants of this class provides more concrete implementation of the model loading and query generation