Skip to content
EasyQuery.NET
Search
Ctrl
K
Cancel
Home
Demo
Introduction
Getting Started
From a 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
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
Dynamic queries for ASP.NET Core projects with Entity Framework Core
Getting started for ASP.NET 4 (MVC or WebForms)
Getting started for WPF
Getting started for Windows Forms
EasyQuery 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
Using EqMvcDemoEF sample with your own DB context
Using MS SQL instead of Access in WebDemo sample project
EasyQuery ASP.NET - using jQuery widgets in a WebForms 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
Working with several data models
Query saving and loading
Custom client-side dialogs for saving/loading operations
EasyQuery.JS widgets localization
Adhoc reporting page in your web application
Attaching extra data to a query on the client-side
Exporting query results
HAVING and GROUP BY clauses in generated query
Paging in query results
Lookup fields and columns
Managing data formats in client-side widgets (grid, charts) and exported data
Custom DateTimePicker in QueryPanel
Adding a new operator to your data model
Create virtual (calculated) attribute in you model
Common SQL queries
Simple query over one table
Query with table joins
Query with OR operators
Aggregate data
Query with a subquery
Previous versions' tutorials (obsolete)
Localization of query builder's UI
Possible ways of data model creation and loading
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)
Gridview filtering with EasyQuery ASP.NET (WebForms)
JavaScript widgets formats and settings (Webforms)
Advanced search page in your MVC app in 5 minutes
How to
Adding columns and conditions with code
How to add an extra condition to your query
Building data model dynamically by DB meta-information
Navigate through data model entities and attributes
User-friendly name for tables
Navigate through query conditions
Dynamically populate value lists by information from other conditions
Version 5.x
How to restrict access to EasyQuery middleware for non-authenticated users
Store queries in a database
Creating data model dynamically with 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)
Setting anti-forgery token for AJAX requests from EasyQuery widgets
How to save/load queries to/from database
Building data model dynamically using code (version 3.x)
Dynamically populate lists by information from other conditions — WebForms
How to setup SQL LIST value editor in WinForms app
How to make a field to field comparison
Building data model dynamically by information from a DataTable
Create a query with sub-query by code
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
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
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
Version 7.2 release notes
Version 7.0 release notes
Version 5.x release notes
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.x 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 4.2.0 release notes
Version 4.1.0 release notes
Version 4.0 release notes
Version 3.x releases
Version 3.10.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
API reference
EasyData.Core
EasyData namespace
BadJsonFormatException class
BitOptions class
ColumnAlignment enum
CommonExtensions class
ConstListValueEditor class
ConstValueItem class
ConstValueList class
CustomListValueEditor class
CustomValueEditor class
DataType enum
DataTypeList class
DataUtils class
DateTimeValueEditor class
EasyDataCol class
EasyDataColDesc class
EasyDataColStyle class
EasyDataResultSet class
EasyDataRow class
EditorTags class
EntityAttrKind enum
IDefaultValuesStorage interface
IEasyDataResultSet interface
IValueEditorCreator interface
ListValueEditor class
MetaData class
MetaDataException class
MetaDataReadWriteOptions class
MetaEntity class
MetaEntityAttr class
MetaEntityAttrDescriptor class
MetaEntityAttrList class
MetaEntityAttrStore class
MetaEntityList class
MetaEntityStore class
StringExtensions class
TextValueEditor class
ValueEditor class
ValueEditorException class
ValueEditorList class
ValueEditorStore class
EasyData.Export namespace
BasicDataExportSettings class
IDataExporter interface
IDataExportSettings interface
EasyData.Services namespace
ContainerNotFoundException class
EasyDataManager class
EasyDataManagerException class
EasyDataOptions class
EasyFilter class
EntityNotFoundException class
EasyData.Exporters.ClosedXML
EasyData.Export namespace
ExcelDataExporter class
ExcelDataExportSettings class
EasyData.Exporters.Default
EasyData.Export namespace
CsvDataExporter class
CsvDataExportSettings class
ExcelHtmlDataExporter class
ExcelHtmlDataExportSettings class
HtmlDataExporter class
HtmlDataExportSettings class
EasyData.Exporters.PdfSharp
EasyData.Export namespace
PdfDataExporter class
PdfDataExportSettings class
Korzh.EasyQuery
Korzh.EasyQuery namespace
AggrFuncExpr.ArgStore class
AggrFuncExpr class
AggrFunction class
AggrFunctionDescriptor struct
AggrFunctionList class
BadJsonFormatException class
ChangeType enum
ColumnDescriptor struct
CommonExtensions class
Condition class
Condition.LinkType enum
ConditionExprList class
ConditionList class
ConditionsChangeEventArgs class
ConditionsStore class
ConditionTag enum
ConstExpr class
ConstListValueEditorXmlSerializer class
CustomListValueEditorXmlSerializer class
CustomValueEditorXmlSerializer class
DataKind enum
DataModel class
DataModel.Error class
DataModel.TypeOperatorEntry class
DataModel.TypeOperatorMap class
DataModelXmlSerializer class
DateTimeValueEditorXmlSerializer class
DisplayFormatParser class
DisplayFormatParser.TokenType enum
DrillDownStore class
EdgeInfo class
EditorsMap class
EmptyQueryBuilderResult class
Entity class
EntityAttr class
EntityAttrDescriptor class
EntityAttrExpr class
EntityAttrStore class
EntityAttrXmlSerializer class
EntityAttrXmlSerializer<T> class
EntityGraph class
EntityStore class
EntityXmlSerializer class
EqEditorTags class
EqEntityAttrAttribute class
EqEntityAttribute class
EqExpression class
EqExpressionException class
EqListValueEditorAttribute class
EqValueEditorCreator class
EqVersionInfo class
ExprList class
ExprTag class
IColumnDescriptor interface
IDataModelSerializer interface
IExpressionCreator interface
IMacroValue interface
IProgressIndicator interface
IQueryBuilder interface
IQueryStatement interface
License class
ListValueEditorXmlSerializer class
ListValueEditorXmlSerializer<T> class
MacroList class
MacroRequestEventArgs class
ModelReadWriteOptions class
NoPathResolution enum
NotEnoughModelInfo class
ObjectGraph<T> class
ObjectModelType class
ODataQueryBuilder class
ODataStatement class
Operand class
OperandList class
OperandXmlSerializer class
Operator class
OperatorGroup class
OperatorGroupKind enum
OperatorGroupList class
OperatorList class
OperatorStore class
OperatorXmlSerializer class
OperatorXmlSerializer<T> class
ParentColumnExpr class
ParentEntityAttrExpr class
Query class
Query.Error class
QueryBuilderError class
QueryBuilderOptions class
QueryColumn class
QueryColumnChangingEventArgs class
QueryColumnList class
QueryColumnsChangeEventArgs class
QueryColumnStore class
QueryException class
QueryExpr class
QueryParam class
QueryParamList class
QueryParamListXmlSerializer class
QueryReadWriteOptions class
QueryStatement class
QueryTextFormats class
QueryTextFormats.HtmlFormats class
ScalarExprOptions enum
SimpleMacroValue class
SortDirection enum
SortedColumnList class
SortOrderChangedEventArgs class
SpecialDateTime enum
SqlListValueEditor class
SqlListValueEditorXmlSerializer class
SqlSyntax enum
StringExtensions class
StringTokenizer class
StringTokenizer.TokenType enum
SubQueryValueEditor class
TextResources class
TextValueEditorXmlSerializer class
TypeExtensions class
Utils class
ValueEditorEntry class
ValueEditorXmlSerializer class
ValueEditorXmlSerializer<T> class
XmlSerializer class
XmlSerializer<T> class
XmlSerializerFactory class
Korzh.EasyQuery.Services namespace
ChunkSettings class
CustomValueListResolver class
DataFetchMeta class
EasyQueryManager class
EasyQueryManagerException class
EasyQueryOptions class
EasyResultSet class
EmptyServiceProvider class
EqAction class
EqResultSetError class
EqResultSetExtensions class
EqTrivialAuthProvider class
FileModelLoader class
FileModelLoaderSettings class
FileQueryStore class
FileQueryStoreSettings class
IDataExportTuner 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
ModelNotFoundException class
PagedList<T> class
QueryListItem class
QueryNotFoundException class
QueryStorageException class
ResultSetOptions class
TotalsContainer.TotalsContainerBuilder class
TotalsOptions class
TotalsOptions.ColOptions class
Korzh.Utils namespace
TextStorage class
TextStorageMap class
Microsoft.Extensions.DependencyInjection namespace
EasyQueryServicesBuilder class
Korzh.EasyQuery.AspNet4
Korzh.EasyQuery.AspNet namespace
ControllerExtensions class
DependencyScopeServiceProvider class
EasyQueryApiController class
EasyQueryManagerExtensions class
EqErrorActionResult class
EqErrorHttpActionResult class
EqHtmlHelpers class
EqMvcExtensions class
EqOkActionResult class
EqOkHttpActionResult class
JSLicense class
License class
Korzh.EasyQuery.AspNetCore
Korzh.EasyQuery.AspNetCore namespace
EasyQueryApiHandler class
EasyQueryManagerExtensions class
EasyQueryMiddleware class
EasyQueryMiddleware<THandler> class
EqControllerBaseExtentions class
EqErrorResult class
EqHtmlHelpers class
EqMvcExtensions class
EqOkResult class
HighlightSelectedTextTagHelper class
JSLicense class
License class
PageNavigatorTagHelper class
Korzh.EasyQuery.Services namespace
DefaultEqAuthProvider class
EasyQueryOptionsExtentionsAuth class
EqSessionCachingService class
Microsoft.AspNetCore.Builder namespace
EasyQueryEndpointRouteBuilderExtensions class
EasyQueryMiddlewareExtensions class
Microsoft.AspNetCore.Http namespace
HttpResponseExtensions class
Microsoft.Extensions.DependencyInjection namespace
EasyQueryServicesBuilderExtensionsAspNetCore class
Korzh.EasyQuery.DataExport
Microsoft.Extensions.DependencyInjection namespace
EasyQueryServicesBuilderExtentionsDataExport class
Korzh.EasyQuery.Db
Korzh.EasyQuery.Db namespace
AutoLinker class
ColumnAliasesUsage enum
ColumnExtensions class
ConditionSqlGeneratedEventArgs class
CustomSqlColumnDescriptor struct
CustomSqlExpr class
DbConnectionLoaderOptions class
DbConnectionModelLoaderOptions class
DbEntityAttr class
DbEntityAttrDescriptor class
DbEntityAttrXmlSerializer class
DbExprTag class
DbFieldInfo class
DbFieldInfoList class
DbGate class
DbGateException class
DbGateList class
DbInfo class
DbInfoList class
DbLinkInfo class
DbLinkInfoList class
DbModel class
DbModelExtensions class
DbModelXmlSerializer class
DbOperator class
DbOperatorXmlSerializer class
DbParam class
DbParameters class
DbQuery class
DbQueryBuilder class
DbTable class
DbTableInfo class
DbTableInfoList class
DbTableXmlSerializer class
DbUtils class
EOLSymbol enum
FilterExpression class
FilterExpressionBuilder class
FormatType enum
IConnectionStringBuilderDlg interface
JoinsOrder enum
LinkCondType enum
LoginRequestEventArgs class
OrderByStyles enum
Path class
PathList class
ResultSetPortion class
ResultTableNode class
SqlDialect class
SqlDialectList class
SqlExtras class
SqlFormats class
SqlQueryBuilder class
SqlQueryBuilderExtensions class
SqlStatement class
Table class
TableCategory class
TableCategoryList class
TableLink class
TableLink.Condition class
TableLink.ConditionList class
TableLinkList class
TableLinkStore class
TableLinkStoreException class
TableLinkType enum
TableLinkXmlSerializer class
TableList class
TableListException class
TablePathFinder class
TableStore class
TableXmlSerializer class
TableXmlSerializer<T> class
UsedTableList class
VirtualTable class
VirtualTableXmlSerializer class
XmlExtensions class
Korzh.EasyQuery.Services namespace
DbConnectionModelLoader class
EasyDbResultSet class
EasyQueryManagerSql class
EasyQueryOptionsExtentionsDb class
IDbResultSet interface
SqlValueListResolver class
SqlValueListResolverException class
Microsoft.Extensions.DependencyInjection namespace
EasyQueryManagerSqlResolver class
EasyQueryServicesBuilderExtensionsSql class
Korzh.EasyQuery.EntityFramework6
Korzh.EasyQuery.EntityFramework namespace
DbContextLoaderException class
DbContextModelExtractor class
DbContextModelExtractorException class
DbContextModelExtractorOptions class
EdmxModelExtractorOptions class
EntityFrameworkExtensions class
Korzh.EasyQuery.Services namespace
DbContextModelLoader class
EasyQueryOptionsExtensionsEf class
EdmxFileModelLoader class
Korzh.EasyQuery.EntityFrameworkCore.Identity
Korzh.EasyQuery.EntityFrameworkCore namespace
DbContextExtractorOptionsExtensionsIdentity class
Korzh.EasyQuery.Services namespace
EasyQueryOptionsExtensionsEfCoreIdentity class
Korzh.EasyQuery.EntityFrameworkCore.Relational
Korzh.EasyQuery.EntityFrameworkCore namespace
DbContextLoaderException class
DbContextModelExtractor class
DbContextModelExtractorException class
DbContextModelExtractorOptions class
EntityFrameworkCore2Extensions class
EntityFrameworkCore3PlusExtensions class
EntityFrameworkCoreExtensions class
Korzh.EasyQuery.Services namespace
DbContextModelLoader<T> class
EasyQueryOptionsExtensionsEfCore class
Korzh.EasyQuery.Linq
Korzh.EasyQuery namespace
ContextLoadingMapper class
LinqTypeExtensions class
Korzh.EasyQuery.Linq namespace
BuilderResult<T> class
ContextLoadingOptions enum
EntityAttrTypeLoader class
EntityLinqExtensions class
EntityTypeLoader class
EqSortByEnumNamesAttribute class
FullTextSearchOptions class
LinqBuilderExtensions class
LinqOperator class
LinqQueryBuilder class
LinqQueryBuilderError class
LinqStatement class
MergeTypesStrategy enum
ModelLinqExtensions class
ObjectModelLoader class
ObjectModelLoaderError class
PropertyInfoExtensions class
Korzh.EasyQuery.Services namespace
EasyObjectResultSet class
EasyQueryManagerLinq<T> class
EasyQueryOptionsExtensionsLinq class
EntityTypeModelLoader<T> class
EntityTypeModelLoaderOptions class
IObjectResultSet interface
Microsoft.Extensions.DependencyInjection namespace
EasyQueryManagerLinqResolver<T> class
EasyQueryServicesBuilderExtensionsLinq class
Korzh.EasyQuery.MySqlGate
Korzh.EasyQuery.DbGates namespace
MySqlGate class
Korzh.EasyQuery.NpgSqlGate
Korzh.EasyQuery.DbGates namespace
NpgSqlGate class
Korzh.EasyQuery.OdbcGate
Korzh.EasyQuery.DbGates namespace
OdbcGate class
Korzh.EasyQuery.OdpCoreGate
Korzh.EasyQuery.DbGates namespace
OdpCoreGate class
Korzh.EasyQuery.RazorUI
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.RazorUI namespace
ChartLibrary enum
EqRazorPageSettings class
Globals class
Pages class
Korzh.EasyQuery.SqLiteGate
Korzh.EasyQuery.DbGates namespace
SqLiteGate class
Korzh.EasyQuery.SqlServerGate
Korzh.EasyQuery.DbGates namespace
SqlClientGate class
SqlServerGate class
Korzh.EasyQuery.WinForms
Korzh.EasyQuery.WinForms namespace
ActionEventArgs class
AggrColumnRow class
BeforeRollUpEventArgs class
ButtonListXElement class
ButtonListXElement.Creator class
ColumnRow class
ColumnRowList class
ColumnsPanel class
ColumnsPanel.ColumnsPanelViewOptions class
ColumnsPanel.Error class
ColumnsPanelEditMode enum
ConditionGroupRow class
ConditionRenderEventArgs class
ConditionRow class
ConditionRowList class
ConditionRowOptions enum
CondLinkType enum
ContentChangedEventArgs class
CreateValueElementEventArgs class
DateTimeXElement class
DateTimeXElement.Creator class
EditXElement class
EditXElement.Creator class
EntitiesPanel class
EntitiesPanel.Error class
FilterOptions enum
IColumnRowCreator interface
LabelXElement class
LabelXElement.Creator class
License class
ListBoxListControl class
ListControl class
ListRequestEventArgs class
ListXElement class
ListXElement.Creator class
MacButton class
MacButton.MState enum
MenuListControl class
MenuListControl.ListMenuItem class
NodeAddingEventArgs class
QueryPanel class
QueryPanel.Error class
QueryPanel.ParamRow class
QueryPanel.QueryPanelViewOptions class
QueryPanelEditMode enum
ShowAttrOptions enum
Signals enum
SimpleColumnRow class
SimpleConditionRow class
SortingPanel class
SortingPanel.SCPAppearance class
SortingPanel.SimpleSortingRow class
SortingPanel.SortEditModeKind enum
SqlExecuteEventArgs class
SqlListXElement class
SqlListXElement.Creator class
StringTokenizer class
SubQueryForm class
SubQueryXElement class
SubQueryXElement.Creator class
TextAdjustingEventArgs class
TextResources class
TextXElement class
TextXElement.Creator class
Utils class
ValidateValueEventArgs class
ValueItem class
ValueItemList class
ValueRequestEventArgs class
XElement class
XElement.Error class
XElement.ICreator interface
XElementList class
XElementsStore class
XPanel class
XPanel.XViewOptions class
XRow class
XRowList class
XSortOrder enum
Korzh.EasyQuery.WinForms.ModelEditor
Korzh.EasyQuery.WinForms.ModelEditor namespace
Korzh.EasyQuery.WinForms.ModelEditor namespace
AboutDlg class
AttrExprBuilder class
ConfigSettings class
DbItemsDlg class
DbItemsDlg.Params class
DbItemType enum
EntityDlg class
EntityDlg.Params class
EntityDlgType enum
Globals class
IJsonConvertor interface
LinkPropsDlg class
ModelEditorForm class
ModelPropsDlg class
ProgressBarDlg class
ValueEditorPropsDlg class
XPStyle class
Korzh.EasyQuery.Wpf
Korzh.EasyQuery.Wpf namespace
AggrColumnRow class
ColumnButton class
ColumnsPanel class
ColumnsPanel.EditModeKind enum
ConditionButton class
ConditionGroupRow class
DateEditXElement class
DateXElement class
EditModeKind enum
EditXElement class
EntitiesPanel class
EntityMenuFillerSettings class
EntityTreeNode class
ImageLoader class
ItemAddingEventArgs class
IXElementCreator interface
License class
ListBoxExtenders class
ListRequestEventArgs class
ListXElement class
QueryPanel class
SimpleColumnRow class
SimpleConditionRow class
SimpleSortingRow class
SortingButton class
SortingPanel class
SubQueryXElement class
TextResources class
ValueItem class
ValueItemList class
ValueRequestEventArgs class
WpfControlsExtensions class
WpfUtils class
XElement class
XElementList class
XPanel class
XRow class
XRowList class
XSortOrder enum
API reference 4x
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
ContextLoadingMapper 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
EqJsonExtensions class
EqListValueEditorAttribute class
EqVersionInfo class
ExprList class
IConditionCreator interface
IDefaultValuesStorage interface
IExpressionCreator interface
IMacroValue interface
IProgressIndicator interface
IQueryBuilder interface
IValueEditorCreator interface
JsonDict class
JsonDictConverter class
License class
LinqTypeExtensions class
ListValueEditor class
MacroList class
MacroRequestEventArgs class
NoPathResolution enum
NotEnoughModelInfo class
ObjectGraph<T> class
ObjectModelType class
ODataQueryBuilder class
ODataStatement class
Operand class
OperandList class
Operator class
OperatorGroup class
OperatorGroupList class
OperatorList class
OperatorStore class
OrderByStyles enum
Predicate class
Query class
QueryBuilderError 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
SpecialDateTime enum
SqlListValueEditor class
SqlSyntax enum
StringExtensions class
StringTokenizer class
SubQueryValueEditor class
TextResources class
TextValueEditor class
TimeMacro class
TimeMacroType enum
TypeExtensions class
Utils class
ValueEditor class
ValueEditorEntry class
ValueEditorsList class
Korzh.EasyQuery.AspNetCore namespace
EqHtmlHelpers class
EqMvcExtensions class
HighlightSelectedTextTagHelper class
ListViewOptions 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.DbGates namespace
MySqlGate class
NpgSqlGate class
OdpCoreGate class
SqlClientGate class
SqLiteGate class
Korzh.EasyQuery.EntityFrameworkCore namespace
DbContextLoader class
DbContextOptions enum
EntityFrameworkExtensions class
IQueryableExtensions class
Korzh.EasyQuery.EntityFrameworkCore.Relational namespace
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.Services namespace
EqModelNotFoundError class
EqRequestOptions class
EqResultSetError class
EqServiceError class
EqServiceProvider class
EqServiceProviderDb class
EqServiceProviderLinq class
ExportOptions class
GdtDbResultSet class
GdtObjectResultSet class
GdtResultSet class
IDbResultSet interface
IEqResultSet interface
IPagedList<T> interface
IPaging interface
ListItem class
ListItemComparer class
ListRequestOptions class
PagedList<T> class
PagingSettings class
QueryListItem class
Korzh.Utils namespace
Test section2
TextStorage class
TextStorageMap class
API reference 5x
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
Home
Demo
Possible ways of data model creation and loading
This article is obsolete.
For the latest version please read
Working with data models in EasyQuery
