Connect to your database
/getting-started/from-sample-to-your-own-project/connect-to-your-databaseThis article describes how to modify our sample project to make it work with your own database instead of Northwind DB used by default.
Generating queries for 2 (or more) databases
/how-to/querying-several-databasesHere you can find tricks for executing this task
How to save/load queries to/from database
/how-to/mvc-save-load-query-databaseFind out how to change this default behavior and save/load queries to any other storage
Store queries in a database
/how-to/store-queries-in-a-databaseHere we describe the case when all users of some web application create their own queries and would like to store those queries in some database.
EqExpression class
/api-reference-5x/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
EqExpression class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/eqexpression-classRepresents common expression object.
Terminology
/fundamentals/terminologyCommon terms Database - may refer to any data storage but in most cases we mean some relational database such as MS SQL Server, My SQL, Oracle, etc. Result set - a result of some search request (query). Usually, is presented as tabular data. Query - a search request. Query condition - one of the search terms (for example: "Customer name starts with 'A'")
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.
Data Model
/fundamentals/data-modelIn short (and by its name), data model - is a model (representation) of some data stored in your database. It solves two major problems: Presents the data to the end user in a more friendly and familiar way. Contains some meta information that helps EasyQuery components to build query statements in SQL or other query languages. Any data model contains the following main sections:
DbExprTag class
/api-reference-5x/korzh-easyquery-db-namespace/dbexprtag-classContains several constants for db-related expressions tags values
DbExprTag class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbexprtag-classContains several constants for db-related expressions tags values
Introduction
/introductionIf in short, EasyQuery - set of components that allow you (as a developer) to implement a functional, user-friendly query builder in your application
ExprTag class
/api-reference-5x/korzh-easyquery-namespace/exprtag-classContains several constant definitions for expressions tag
DbModel class
/api-reference-4x/korzh-easyquery-db-namespace/dbmodel-classDatabase-related implementation of [Korzh.EasyQuery.DataModel](api-reference-4x/korzh-easyquery-namespace/datamodel-class) class. In addition to the basic data it contains also list of database tables and the links between them.
ExprTag class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/exprtag-classContains several constant definitions for expressions tag
QueryExpr class
/api-reference-5x/korzh-easyquery-namespace/queryexpr-classRepresents a sub-query expression
CustomSqlExpr class
/api-reference-5x/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression
DbGate class
/api-reference-4x/korzh-easyquery-db-namespace/dbgate-classRepresents base class which allows to get DB structure information availble for some connection
QueryExpr class
/api-reference/korzh-easyquery/korzh-easyquery-namespace/queryexpr-classRepresents a sub-query expression
CustomSqlExpr class
/api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/customsqlexpr-classRepresents a custom SQL expression