Home
EasyQuery
EasyQuery.NET
EasyQuery.JS
EasyReport Starter Kit
Localizer
Blog
Support
EasyQuery.NET Docs
API reference
Introduction
Getting Started
From sample to your own project
Connect to your database
Copying the EasyQuery's code from a sample to your project
Getting started for EasyQuery with ASP.NET Core
Getting started for ASP.NET Core + MVC or Razor pages
Dynamic queries for ASP.NET Core projects with Entity Framework Core
Getting started with EasyQuery in ASP.NET Core + Angular project
Getting started for ASP.NET Core + React project
Getting started for ASP.NET Core + Vue project
Getting started for ASP.NET 4 (MVC or WebForms)
Getting started for WPF
Getting started for Windows Forms
Product/license key
Version 4.x (obsolete)
Getting started for EasyQuery ASP.NET Core (version 4.x)
Version 3.x (obsolete)
Getting started for EasyQuery ASP.NET MVC
Getting started for ASP.NET WebForms
Getting started for WPF
Getting started for Windows Forms
EasyQuery ASP.NET - using jQuery widgets in a WebForms project
Using EqMvcDemoEF sample with your own DB context
Using MS SQL instead of Access in WebDemo sample project
Getting started for Silverlight
Fundamentals
Terminology
How it works
Data Model
Introduction to value editors
EasyQuery client-side views
Tutorials
Working with data models in EasyQuery
Possible ways of data model creation and loading
Working with several data models
Query saving and loading
Custom client-side dialogs for saving/loading operations
EasyQuery.JS widgets localization
Attaching extra data to a query on the client-side
Version 3.x tutorials (obsolete)
Localization of query builder's UI
Building dynamic queries with EasyQuery and Entity Framework
Localization of EasyQuery widgets (obsolete)
Dynamic PHP query builder with EasyQuery
JavaScript widgets formats and settings (MVC version)
JavaScript widgets formats and settings (Webforms)
Exporting query results
HAVING and GROUP BY clauses in generated query
Paging in query results
Lookup fields and columns
Result grid formatting on the client-side
Adding a new operator to your data model
Create virtual (calculated) attribute in you model
Gridview filtering with EasyQuery ASP.NET (WebForms)
Common SQL queries
Simple query over one table
Query with table joins
Query with OR operators
Aggregate data
Query with a subquery
How to
Version 5.x
How to restrict access to EasyQuery middleware for non-authenticated users
Store queries in a database
Creating data model dynamically using code
Processing custom value editors in EasyQuery JS
Dynamic populating of value lists in WinForms or WPF editions
Obsolete (for version 3.x or lower)
How to save/load queries to/from database
Setting anti-forgery token for AJAX requests from EasyQuery widgets
How to setup SQL LIST value editor in WinForms app
How to make field to field comparison
User-friendly name for tables
Building data model dynamically by information from DataTable
Building data model dynamically using code (version 3.x)
Building data model dynamically by DB meta-information
Adding columns and conditions with code
Add an extra condition to your query
Create a query with sub-query by code
Navigate through query conditions
Navigate through data model entities and attributes
Generating queries for 2 (or more) databases
Setup custom value editor — WinForms
Replace "value" element in QueryPanel's conditions — WinForms
Hide some entities and/or attributes
Dynamically populate lists by information from other conditions — WebForms
Dynamically populate lists by information from other conditions - MVC
Add query builder page from our MVC sample project in your own app
How to add a column with the same attribute as in newly added condition
Processing custom value editors in EasyQuery JS (Obsolete)
Add a new aggregate function
Using parameters in query conditions
Build query by code on the client-side
How to remove "Powered by..." link (full version only)
How to limit columns from duplication
Date/time values formatting
Customizing common SQL clauses
Adhoc reporting page in your web application
Customizing SQL query formats
How to show descriptive texts in some column instead of numeric values
Data Model Editor
About Data Model Editor
Tables and links page
Working with table aliases
Edit link dialog
Entities page
Operators page
Value Editors
End-user's guide
Release Notes
Changelog
EasyQuery.NET 5.4.1 + EasyQuery.JS 6.1.0 release notes
Version 5.3 + EasyQuery.JS 6.0 release notes
Version 5.2 release notes
Version 5.1 release notes
Version 5.0 release notes
Version 4.4.2 release notes
Version 4.4.1 release notes
Version 4.4.0 release notes
Version 4.3.1 release notes
Version 3.10.0 release notes
Version 4.2.0 release notes
Version 4.1.0 release notes
Version 4.0 release notes
Version 3.9.0 release notes
Version 3.8.0 release notes
Version 3.7.0 release notes
Version 3.6.0 release notes
Version 3.5.0 release notes
Version 3.4.0 release notes
Version 3.0 release notes
Upgrade instructions
Upgrade instructions: EasyQuery.NET 5.3 + EasyQuery.JS 6.0
Upgrade instructions. From Version 3.x to 5.x for .NET Framework 4.x projects
Upgrading to 5.x: WinForms and WPF projects
Upgrading to 5.x: ASP.NET (MVC and WebForms) projects
Upgrading from version 4.x to 5.x
Upgrading from version 3.x to 4.0
Upgrading from version 2.x to 3.0
API reference
AspNetCore namespace
Pages_EasyQuery_AdHocReporting class
Pages_EasyQuery_AdvancedSearch class
Pages_EasyQuery_DataFiltering class
Pages_Shared_EasyQuery__AdHocReporting class
Pages_Shared_EasyQuery__AdvancedSearch class
Pages_Shared_EasyQuery__DataFiltering class
Korzh.EasyQuery namespace
AggrFuncExpr class
AggrFunction class
AggrFunctionList class
BadJsonFormatException class
BaseQueryBuilder class
ChangeType enum
Column class
ColumnAliasesUsage enum
ColumnList class
ColumnsChangeEventArgs class
ColumnsChangingEventArgs class
ColumnStore class
CommonExtensions class
Condition class
ConditionExprList class
ConditionList class
ConditionsChangeEventArgs class
ConditionsStore class
ConditionTag enum
ConstExpr class
ConstListValueEditor class
ConstValueItem class
ConstValueList class
ContextLoadingMapper class
CustomListValueEditor class
CustomValueEditor class
DataKind enum
DataModel class
DataType enum
DataTypeList class
DateTimeValueEditor class
DisplayFormatParser class
EdgeInfo class
EditorsMap class
EditorTags class
EmptyQueryBuilderResult class
Entity class
EntityAttr class
EntityAttrExpr class
EntityAttrList class
EntityAttrProp enum
EntityAttrStore class
EntityGraph class
EntityList class
EntityStore class
EOLSymbol enum
EqEntityAttrAttribute class
EqEntityAttribute class
EqExpression class
EqExpressionException class
EqListValueEditorAttribute class
EqValueEditorException class
EqVersionInfo class
ExprList class
ExprTag class
IDefaultValuesStorage interface
IExpressionCreator interface
IMacroValue interface
IProgressIndicator interface
IQueryBuilder interface
IQueryFormats interface
IValueEditorCreator interface
License class
LinqTypeExtensions class
ListValueEditor class
MacroList class
MacroRequestEventArgs class
ModelReadWriteOptions enum
NoPathResolution enum
NotEnoughModelInfo class
ObjectGraph<T> class
ObjectModelType class
ODataQueryBuilder class
ODataQueryBuilderFormats class
ODataStatement class
Operand class
OperandList class
Operator class
OperatorGroup class
OperatorGroupKind enum
OperatorGroupList class
OperatorList class
OperatorStore class
OrderByStyles enum
ParentEntityAttrExpr class
Query class
QueryBuilderError class
QueryBuilderResult class
QueryExpr class
QueryFormats class
QueryParam class
QueryParamList class
QueryReadWriteOptions enum
QueryTextFormats class
RootEntity class
ScalarExprOptions enum
SimpleMacroValue class
SortDirection enum
SortedColumnList class
SortOrderChangedEventArgs class
SpecialDateTime enum
SqlListValueEditor class
SqlSyntax enum
StringExtensions class
StringTokenizer class
SubQueryValueEditor class
TextResources class
TextValueEditor class
TypeExtensions class
Utils class
ValueEditor class
ValueEditorEntry class
ValueEditorList class
ValueEditorStore class
Korzh.EasyQuery.AspNetCore namespace
EasyQueryManagerExtensions class
EasyQueryMiddleware class
EqControllerBaseExtentions class
EqHtmlHelpers class
EqMvcExtensions class
EqOkResult class
HighlightSelectedTextTagHelper class
License class
ListViewOptions class
Korzh.EasyQuery.Db namespace
CondSqlGenEventArgs class
CustomSqlExpr class
DbColumn class
DbConnectionLoaderOptions class
DbEntityAttr class
DbEntityLink class
DbExprTag class
DbFieldInfo class
DbFieldInfoList class
DbGate class
DbGateException class
DbGateList class
DbInfo class
DbInfoList class
DbLinkInfo class
DbLinkInfoList class
DbModel class
DbOperator class
DbParam class
DbParameters class
DbQuery class
DbQueryBuilder class
DbQueryFormats class
DbTable class
DbTableInfo class
DbTableInfoList class
DbUtils class
EntitySqlQueryBuilder class
EntitySqlStatement class
FilterExpression class
FilterExpressionBuilder class
FormatType enum
IConnectionStringBuilderDlg interface
LinkCondType enum
LinkStore class
LoginRequestEventArgs class
Path class
PathList class
ResultEntity class
ResultEntityList class
ResultSetPortion class
ResultTable class
ResultTableList class
SqlDialect class
SqlDialectList class
SqlExtras class
SqlQueryBuilder class
SqlQueryBuilderExtensions class
SqlStatement class
Table class
TableCategory class
TableCategoryList class
TableLink class
TableLinkList class
TableLinkType enum
TableList class
TableStore class
UsedTableList class
VirtualTable class
XmlExtensions class
Korzh.EasyQuery.DbGates namespace
MySqlGate class
NpgSqlGate class
OdbcGate class
OdpCoreGate class
SqlClientGate class
SqLiteGate class
Korzh.EasyQuery.EntityFrameworkCore namespace
DbContextLoader class
DbContextLoaderException class
DbContextLoaderOptions class
DbContextLoaderOptionsExtensionsIdentity class
EntityFrameworkCore2Extensions class
EntityFrameworkCoreExtensions class
Korzh.EasyQuery.Linq namespace
ContextLoadingOptions enum
EntityAttrTypeLoader class
EntityLinqExtensions class
EntityTypeLoader class
FullTextSearchOptions class
LinqBuilderExtensions class
LinqQueryBuilder class
LinqQueryBuilderError class
LinqQueryBuilderFormats class
LinqStatement class
MergeTypesStrategy enum
ModelLinqExtensions class
ObjectModelLoader class
ObjectModelLoaderError class
PropertyInfoExtensions class
Korzh.EasyQuery.RazorUI namespace
EqRazorPageSettings class
Globals class
Pages class
Korzh.EasyQuery.Services namespace
BasicDataExportSettings class
CsvDataExporter class
CsvDataExportSettings class
CustomValueListResolver class
DbConnectionModelLoader class
DbContextModelLoader<T> class
DefaultEqAuthProvider class
EasyQueryManager class
EasyQueryManagerException class
EasyQueryManagerLinq<T> class
EasyQueryManagerSql class
EasyQueryOptions class
EasyQueryOptionsExtensionsEfCore class
EasyQueryOptionsExtensionsEfCoreIdentity class
EasyQueryOptionsExtensionsLinq class
EasyQueryOptionsExtentionsAuth class
EasyQueryOptionsExtentionsDb class
EntityTypeModelLoader<T> class
EqAction class
EqResultSetError class
EqSessionCachingService class
EqTrivialAuthProvider class
ExcelHtmlDataExporter class
ExcelHtmlDataExportSettings class
ExecuteQueryOptions class
FileModelLoader class
FileModelLoaderSettings class
FileQueryStore class
FileQueryStoreSettings class
GdtCell class
GdtColumn class
GdtDbResultSet class
GdtObjectResultSet class
GdtResultSet class
GdtRow class
IDataExporter interface
IDataExportSettings interface
IDbResultSet interface
IEasyQueryManagerResolver interface
IEasyQueryManagerTuner interface
IEqAuthProvider interface
IEqCachingService interface
IEqResultSet interface
IModelLoader interface
IPagedList<T> interface
IPaging interface
IQueryStore interface
IValueListResolver interface
ListItem class
ListItemComparer class
ListRequestOptions class
LookupValueListResolver class
ModelLoaderException class
PagedList<T> class
PagingSettings class
QueryListItem class
QueryStorageException class
SqlValueListResolver class
SqlValueListResolverException class
Korzh.Utils namespace
TextStorage class
TextStorageMap class
Microsoft.AspNetCore.Builder namespace
EasyQueryMiddlewareExtensions class
Microsoft.AspNetCore.Http namespace
HttpResponseExtensions class
Microsoft.Extensions.DependencyInjection namespace
EasyQueryManagerLinqResolver<T> class
EasyQueryManagerSqlResolver class
EasyQueryServicesBuilder class
EasyQueryServicesBuilderExtensionsAspNetCore class
EasyQueryServicesBuilderExtensionsLinq class
EasyQueryServicesBuilderExtensionsSql class
EasyQueryServicesBuilderExtentionsDataExport class
API reference 4.x (obsolete)
Korzh.EasyQuery namespace
AggrFuncExpr class
AggrFunction class
AggrFunctionList class
BaseQueryBuilder class
ChangeType enum
Column class
ColumnAliasesUsage enum
ColumnList class
ColumnsChangeEventArgs class
ColumnsChangingEventArgs class
ColumnStore class
Condition class
ConditionList class
ConditionsChangeEventArgs class
ConditionsStore class
ConstExpr class
ConstListValueEditor class
ConstValueItem class
ConstValueList class
CustomListValueEditor class
CustomValueEditor class
DataKind enum
DataModel class
DataType enum
DataTypeList class
DateTimeValueEditor class
DisplayFormatParser class
EdgeInfo class
EditorsMap class
EmptyQueryBuilderResult class
EntAttrKind enum
Entity class
EntityAttr class
EntityAttrExpr class
EntityAttrList class
EntityAttrProp enum
EntityAttrStore class
EntityGraph class
EntityList class
EntityStore class
EOLSymbol enum
EqEntityAttrAttribute class
EqEntityAttribute class
EqExpression class
EqListValueEditorAttribute class
EqVersionInfo class
ExprList class
IConditionCreator interface
IDefaultValuesStorage interface
IExpressionCreator interface
IMacroValue interface
IProgressIndicator interface
IQueryBuilder interface
IValueEditorCreator interface
JsonDict class
License class
ListValueEditor class
MacroList class
MacroRequestEventArgs class
NoPathResolution enum
NotEnoughModelInfo class
ObjectGraph<T> class
ObjectModelType class
Operand class
OperandList class
Operator class
OperatorGroup class
OperatorGroupList class
OperatorList class
OperatorStore class
OrderByStyles enum
Predicate class
Query class
QueryBuilderResult class
QueryFormats class
QueryParam class
QueryParamList class
QueryTextFormats class
RootEntity class
ScalarExprOptions enum
SimpleCondExprList class
SimpleCondition class
SimpleMacroValue class
SortDirection enum
SortedColumnList class
SortOrderChangedEventArgs class
SqlListValueEditor class
SqlSyntax enum
StringExtensions class
StringTokenizer class
SubQueryValueEditor class
TextResources class
TextValueEditor class
TimeMacro class
TimeMacroType enum
Utils class
ValueEditor class
ValueEditorEntry class
ValueEditorsList class
ContextLoadingMapper class
EqJsonExtensions class
JsonDictConverter class
LinqTypeExtensions class
ODataQueryBuilder class
ODataStatement class
QueryBuilderError class
SpecialDateTime enum
TypeExtensions class
Korzh.EasyQuery.Db namespace
CompoundExpr class
CondSqlGenEventArgs class
CustomSqlExpr class
DbAggrFuncExpr class
DbColumn class
DbEntity class
DbEntityAttr class
DbEntityAttrExpr class
DbEntityLink class
DbFieldInfo class
DbFieldInfoList class
DbGate class
DbGateList class
DbInfo class
DbInfoList class
DbLinkInfo class
DbLinkInfoList class
DbModel class
DbOperator class
DbParam class
DbParameters class
DbPredicate class
DbQuery class
DbQueryBuilder class
DbQueryFormats class
DbRootEntity class
DbSimpleCondition class
DbTable class
DbTableInfo class
DbTableInfoList class
DbUtils class
EntitySqlQueryBuilder class
EntitySqlStatement class
FillModelOptions enum
FilterExpression class
FilterExpressionBuilder class
FormatType enum
IConnectionStringBuilderDlg interface
IDbCondition interface
ISqlExpression interface
LinkCondType enum
LinkStore class
LoginRequestEventArgs class
ParentEntityAttrExpr class
Path class
PathList class
ResultEntity class
ResultEntityList class
ResultSetPortion class
ResultTable class
ResultTableList class
SqlDialect class
SqlDialectList class
SqlExtraClauses class
SqlQueryBuilder class
SqlStatement class
SubQueryExpr class
Table class
TableCategory class
TableCategoryList class
TableLink class
TableLinkList class
TableList class
TableStore class
UsedTableList class
VirtualTable class
XmlExtensions class
Korzh.EasyQuery.Services namespace
EqRequestOptions class
EqResultSetError class
EqServiceError class
EqServiceProvider class
ExportOptions class
GdtResultSet class
IEqResultSet interface
IPagedList<T> interface
IPaging interface
ListItem class
ListItemComparer class
ListRequestOptions class
PagedList<T> class
PagingSettings class
QueryListItem class
EqModelNotFoundError class
EqServiceProviderDb class
EqServiceProviderLinq class
GdtDbResultSet class
GdtObjectResultSet class
IDbResultSet interface
Korzh.EasyQuery.AspNetCore namespace
EqHtmlHelpers class
EqMvcExtensions class
HighlightSelectedTextTagHelper class
ListViewOptions class
Korzh.EasyQuery.EntityFrameworkCore namespace
DbContextLoader class
DbContextOptions enum
EntityFrameworkExtensions class
IQueryableExtensions class
Korzh.EasyQuery.Linq namespace
ContextLoadingOptions enum
EntityAttrTypeLoader class
EntityLinqExtensions class
EntityTypeLoader class
FullTextSearchOptions class
LinqBuilderExtensions class
LinqQueryBuilder class
LinqQueryBuilderError class
LinqStatement class
MergeTypesStrategy enum
ModelLinqExtensions class
ObjectModelLoader class
ObjectModelLoaderError class
PropertyInfoExtensions class
Korzh.EasyQuery.DbGates namespace
MySqlGate class
NpgSqlGate class
OdpCoreGate class
SqlClientGate class
SqLiteGate class
Korzh.EasyQuery.EntityFrameworkCore.Relational namespace
IQueryableExtensions class
Korzh.Utils namespace
TextStorage class
TextStorageMap class
Test section2
Microsoft.AspNetCore.Http namespace
December 9, 2019
HttpResponseExtensions class
Class HttpResponseExtensions.
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies.
More info
Got it!