Gridview filtering with EasyQuery ASP.NET (WebForms)
/use-cases/gridview-filtering-with-easyquery-aspnet-webformsGridview filtering with EasyQuery ASP.NET (WebForms)
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
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
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
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
EasyQuery ASP.NET - using jQuery widgets on WebForms project
/getting-started/sample-webforms-javascript-webserviceIn this article, you can find the instructions how to replace native WebForms with our jQuery widgets, with extract examples
DbConnectionLoaderOptions class
/api-reference-5x/korzh-easyquery-db-namespace/dbconnectionloaderoptions-classRepresents different options for [Korzh.EasyQuery.Services.DbConnectionModelLoader](api-reference-5x/korzh-easyquery-services-namespace/dbconnectionmodelloader-class) class
Working with data models in EasyQuery
/getting-started/working-with-data-modelThis article will guide you through all issues about working with data models in EasyQuery library. How to load it from the DbContext or from your DB connection, or now to create a new one using Data Model Editor.
Version 5.3 + EasyQuery.JS 6.0 release notes
/release-notes/version-5-3The biggest change in this release is a new major update (version 6.0) of JavaScript library (EasyQuery.JS) used with ASP.NET or ASP.NET Core editions of EasyQuery. Version 5.3 of EasyQuery contains rather small improvements in the core libraries and all .NET editions. Community edition packages include @easyquery/core , @easyquery/ui . All license owners of EasyQuery for ASP.NET or EasyQuery for ASP.NET Core automatically got a license for EasyQuery.JS as well. to set your key, now for ASP.NET Core edition it will be Respectively, you should use Korzh.EasyQuery.AspNet...
DbConnectionModelLoaderOptions class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbconnectionmodelloaderoptions-classRepresents different options for [Korzh.EasyQuery.Services.DbConnectionModelLoader](api-reference/korzh-easyquery-db/korzh-easyquery-services-namespace/dbconnectionmodelloader-class) class
Version 5.0 release notes
/release-notes/version-5-0Version 5.0 is a completely rewritten major update of EasyQuery which now can be used in any ASP.NET Core (version 2.0 and higher) project and with almost any frontend platform (MVC, Razor pages, Angular, React, Vue, etc). There are a lot of changes both on the server-side part and in the client-side library (EasyQuery.JS). Below we will describe the most important ones: Core library
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
Attaching extra data to a query on the client-side
/tutorials/attaching-extra-data-to-query-client-sideSometimes it's necessary to attach some extra data to each query (based on some user's input on the client-side) and then use that extra data on query execution. For example, user might want to specify a date (or a period of time) as an additional filter to the any query. To add some extra data you can use beforeExecuteQuery event handler which can be defined on view initialization: Now if you check in Developer Tools (on Network tab), each .../execute request now includes ad additional data object in the request payload. Now to process this additional request data you can create your own implementation of EasyQueryManager and override its ExecuteQueryCore method. Here is an example: Here we just reconfigure our current query and add in it an additional condition group with a bunch of conditions like SomeColumns contains 'filter text' Finally, you need to register your manager class on EasyQuery middleware initialization: NB: Please note that you can read the ClientData property in any method of your custom manager.
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
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
Customizing SQL query formats
/how-to/customizing-sql-query-formatsDetailed instruction with various examples of how to operate with different query formats.
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)
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.