Dynamic PHP query builder with EasyQuery
/use-cases/dynamic-php-query-builder-with-easyqueryDynamic PHP query builder with EasyQuery
Localization of query builder's UI
/tutorials/query-builder-ui-localizationIn this article, you can find two methods of localization of EasyQuery components
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)
Dynamically populate lists by information from other conditions — WebForms
/how-to/dynamically-populating-list-webformsA code snippet which demonstrates how to execute this task
Microsoft.AspNetCore.Builder namespace
/api-reference/korzh-easyquery-aspnetcore/microsoft-aspnetcore-builder-namespaceBuilding data model dynamically by DB meta-information
/how-to/build-data-model-by-db-meta-informationIt's easier to fill your model right in the code directly from your database, using meta-information
Using parameters in query conditions
/how-to/parameters-in-query-conditionsThis article explains how to work with parameterized conditions.
Query with OR operators
/tutorials/query-with-or-operatorsIn this article, you will learn how to build queries that contain both AND and OR operators.
Building data model dynamically by information from a DataTable
/how-to/build-data-model-by-info-from-datatableExample of how to build data model by certain information from DataTable
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.
Dynamically populate value lists by information from other conditions
/how-to/dynamically-populating-lists-mvcSuppose we have a database with Customer entity which has Country and City attributes. For both these attributes we define the value editors which return the lists of available values (countries and cities correspondingly). Now let's imagine the user adds a condition with the Country attribute e.g. Hera the steps needed to implement such a functionality: Define a value editor for the City attribute as SQL LIST with Cities.@{{Customer.Country}} list name (here Customer.Country is the ID of the Country attribute in the Customer entity). Let's name it "CitesSqlValueList") and then in a value list resolver modify its SQL according the currently selected country and get the list of values using GetValueListAsync method of EasyQueryManager class: What's happening here.
Dynamic populating of value lists in WinForms or WPF editions
/how-to/dynamic-populating-value-list-winforms-wpfExample of how to solve this problem
Query.Error class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/query-error-classQuery exception class.
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
Query class
/api-reference-4x/korzh-easyquery-namespace/query-classRepresents internal query structure.
Query with table joins
/tutorials/query-with-table-joinsAn example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.