This section contains the tutorials for previous versions of EasyQuery.
How to save/load queries to/from database
Find out how to change this default behavior and save/load queries to any other storage
- Introduction
- Getting Started
- From sample to your own project
- Getting started for EasyQuery with ASP.NET Core
- 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)
- 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
- 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)
- 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
- How to
- Version 5.x
- Obsolete (for version 3.x or lower)
- 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
- 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
- API reference
- AspNetCore namespace
- 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
- 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
- Korzh.EasyQuery.EntityFrameworkCore namespace
- 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
- 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
- Microsoft.AspNetCore.Builder namespace
- Microsoft.AspNetCore.Http namespace
- Microsoft.Extensions.DependencyInjection namespace
- 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
- Korzh.EasyQuery.EntityFrameworkCore namespace
- 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
- Korzh.EasyQuery.EntityFrameworkCore.Relational namespace
- Korzh.Utils namespace
- Korzh.EasyQuery namespace