From a sample to your own project
/getting-started/from-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)
/tutorials/version-3-x-tutorialsThis section contains the tutorials that we written for older versions of EasyQuery and most probably are obsolete now.
Copying the EasyQuery's code from a sample to your project
/getting-started/from-sample-to-your-own-project/copying-the-easyquerys-code-from-sample-to-your-projectIf 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
/getting-started/sample-mvc-entity-framework-new-dbcontextThis article contains a brief instruction how to modify EqMvcDemoEF sample project to make it work with your own context class
Adding columns and conditions with code
/how-to/add-columns-conditions-with-codeExample of code for adding columns and conditions
Using MS SQL instead of Access in WebDemo sample project
/getting-started/sample-webforms-change-to-mssqlIn 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
/how-to/build-query-by-code-on-clientsideHere you can find an example of JavaScript code with explanation how to add columns to a current query on client-side.
Creating data model dynamically with code
/how-to/create-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
/how-to/mvc-query-builder-view-in-your-appThis 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)
/how-to/build-data-model-by-codeHere you can find all steps you need to perform
Connect to your database
/getting-started/from-sample-to-your-own-project/connect-to-your-databaseThis article describes how to modify our sample project to make it work with your own database instead of Northwind DB used by default.
Building dynamic queries with EasyQuery and Entity Framework
/tutorials/dynamic-queries-with-easyquery-and-entity-frameworkHere 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)
Getting started for ASP.NET 4
/getting-started/asp-net-4-mvc-or-webformsDescribes the steps you need to perform for applying EasyQuery ASP.NET to your MVC or WebForms project
Getting started for EasyQuery ASP.NET MVC
/getting-started/version-3-x/asp-net-mvcThis article will guide you through all steps necessary to apply EasyQuery ASP.NET to MVC web application
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
Upgrading to 5.x: ASP.NET (MVC and WebForms) projects
/upgrade-instructions/net-framework-3-x-to-5-x-/asp-net-mvc-webformsThis tutorial describes how to upgrde your old ASP.NET MVC project with EasyQuery 3.x to EasyQuery version 5.2.0 (or higher). 1.2 Use NuGet Package Manager to install the following packages: Korzh.EasyQuery.AspNet4 Korzh.EasyQuery.EntityFramewok6 - if you are using Entity Framework 6.x Korzh.EasyQuery.DataExport - if you will need the data exporting functions Korzh.EasyQuery.MsSqlGate (or .MySqlGate or .OdbcGate depending on your DB) - if you need to load your model directly from DB connection. Finally, we need to make some modifications on our pages where we use EasyQuery scripts. Version 5.2.0 and higher of EasyQuery scripts will not need JQuery anymore, so you will be able to throw them away if they are not used in your own pages. Here is an example for "advanced search" view: To update your Web Forms page your will need to do the following 3 steps: Add EasyQuery scripts and styles on your page.