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.
Customizing common SQL clauses
/how-to/customizing-common-sql-clausesThis article is about settings for adding different options to the whole query (like DISTINCT, LIMIT, etc)
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
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
How to setup SQL LIST value editor in WinForms app
/how-to/SQL-LIST-value-editor-in-winforms-appStep-by-step instruction how to setup SQL LIST value editor.
SqlFormats class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/sqlformats-classRepresents different formats of SQL statements.
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
QueryFormats class
/api-reference-4x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
Date/time values formatting
/how-to/date-time-formattingIn this article, you can find instructions how to set up different types of date & time formats, with code examples.
CustomSqlExpr class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression
QueryFormats class
/api-reference-5x/korzh-easyquery-namespace/queryformats-classRepresents different formats of statements.
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.
CustomSqlExpr class
/api-reference-5x/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression
EntitySqlQueryBuilder class
/api-reference-5x/korzh-easyquery-db-namespace/entitysqlquerybuilder-classLets you build Entity SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-5x/korzh-easyquery-db-namespace/dbquery-class) object
EntitySqlQueryBuilder class
/api-reference-4x/korzh-easyquery-db-namespace/entitysqlquerybuilder-classLets you build Entity SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object
SqlQueryBuilder class
/api-reference-4x/korzh-easyquery-db-namespace/sqlquerybuilder-classLets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object
SqlQueryBuilder class
/api-reference-5x/korzh-easyquery-db-namespace/sqlquerybuilder-classLets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-5x/korzh-easyquery-db-namespace/dbquery-class) object