Korzh.EasyQuery.Db namespace

CompoundExpr class

Represents a compound expression (an expression that contains other expressions).

CondSqlGenEventArgs class

Provides data for CondSqlGen event of [Korzh.EasyQuery.Db.SqlQueryBuilder](api-reference-4x/korzh-easyquery-db-namespace/sqlquerybuilder-class) class

CustomSqlExpr class

Represents a custom SQL expression

DbAggrFuncExpr class

Represents an expression with aggregate function

DbColumn class

Represents database table column

DbEntity class

Base SQL Entity

DbEntityAttr class

Base attribute of SQL entity

DbEntityAttrExpr class

An [Korzh.EasyQuery.EqExpression](api-reference-4x/korzh-easyquery-namespace/eqexpression-class) descendant which represents an attribute.

DbEntityLink class

Represents link between two tables

DbFieldInfo class

Represents a structure that contains information about some table field

DbFieldInfoList class

Represents the list of [Korzh.EasyQuery.Db.DbTableInfo](api-reference-4x/korzh-easyquery-db-namespace/dbtableinfo-class) objects

DbGate class

Represents base class which allows to get DB structure information availble for some connection

DbGateList class

Represents the list of `DbGate` objects

DbInfo class

Represents a structure that contains information about some database

DbInfoList class

Represents the list of [Korzh.EasyQuery.Db.DbInfo](api-reference-4x/korzh-easyquery-db-namespace/dbinfo-class) objects

DbLinkInfo class

Represents a structure that contains information about some link between two database tables

DbLinkInfoList class

Represents the list of [Korzh.EasyQuery.Db.DbLinkInfo](api-reference-4x/korzh-easyquery-db-namespace/dblinkinfo-class) objects

DbModel class

Database-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.

DbOperator class

Represents a logical expression or predicate, like comparisons or LIKE predicate.

DbParam class

Represents one entry in [Korzh.EasyQuery.Db.DbParameters](api-reference-4x/korzh-easyquery-db-namespace/dbparameters-class) list

DbParameters class

Represents different parameters of database linked with this [Korzh.EasyQuery.DataModel](api-reference-4x/korzh-easyquery-namespace/datamodel-class) object

DbPredicate class

Represents predicate in [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class)

DbQuery class

Represents query for building SQL command

DbQueryBuilder class

Lets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object

DbQueryFormats class

Represents different formats of SQL statements.

DbRootEntity class

Represents [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) root entity

DbSimpleCondition class

Represents simple condition in [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class)

DbTable class

Represents one table in [Korzh.EasyQuery.Db.DbModel](api-reference-4x/korzh-easyquery-db-namespace/dbmodel-class) object which corresponds to some database table

DbTableInfo class

Represents a structure that contains information about some database table

DbTableInfoList class

Represents the list of [Korzh.EasyQuery.Db.DbTableInfo](api-reference-4x/korzh-easyquery-db-namespace/dbtableinfo-class) objects

DbUtils class

Different utilties for database-oriented operations For internal use only

EntitySqlQueryBuilder class

Lets you build Entity SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object

EntitySqlStatement class

Represents the result of performing BuildSQL command.

FillModelOptions enum

Options for filling model by FillByDbGate method

FilterExpression class

Represents the result of performing BuildSQL command.

FilterExpressionBuilder class

Used for building Sql commands using [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class)

FormatType enum

Represents different database types

IConnectionStringBuilderDlg interface

Defines methods for ConnectionString Builder dialog

IDbCondition interface

Used for conditions in [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class)

ISqlExpression interface

Used for expressions in [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class)

LinkCondType enum

Represents the type of linking condition (field-to-field, field-to-expression, etc.)

LinkStore class

Represetns storage of links.

LoginRequestEventArgs class

Provides data for [Korzh.EasyQuery.Db.DbGate.LoginRequest](api-reference-4x/korzh-easyquery-db-namespace/dbgate-class) event

ParentEntityAttrExpr class

Represents parent entity attribute expression

Path class

Represents list of tables which are linked to each other

PathList class

Represents list of paths.

ResultEntity class

Represents a table used in query.

ResultEntityList class

Represents list of result tables.

ResultSetPortion class

Represents a portion of result set to return

ResultTable class

Represents a table used in query.

ResultTableList class

Represents list of result tables.

SqlDialect class

Represents some dialect of SQL syntax (like Oracle, MySQL, ANSI 92, etc)

SqlDialectList class

Represents different dialects of SQL

SqlExtraClauses class

Represents different extra clauses of SELECT query.

SqlQueryBuilder class

Lets you build SQL commands based on [Korzh.EasyQuery.Db.DbQuery](api-reference-4x/korzh-easyquery-db-namespace/dbquery-class) object

SqlStatement class

Represents the result of performing BuildSQL command.

SubQueryExpr class

Represents a sub-query expression

Table class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference-4x/korzh-easyquery-db-namespace/dbmodel-class) object

TableCategory class

Represents a category of tables

TableCategoryList class

Represents a list of table categories

TableLink class

Represents link between two tables

TableLinkList class

Represents list of the links ([Korzh.EasyQuery.Db.TableLink](api-reference-4x/korzh-easyquery-db-namespace/tablelink-class) objects).

TableList class

Represents list of the [Korzh.EasyQuery.Db.Table](api-reference-4x/korzh-easyquery-db-namespace/table-class) objects.

TableStore class

Represetns storage of tables.

UsedTableList class

Represents a list of "used" tables. The only difference with orginal TableList is that this class doesn't allow to insert already existing table and inserts tables in list according their priority

VirtualTable class

Represents a virtual table. Virtual tables do not correpond to some table in database but are defined through some SQL SELECT statement instead.

XmlExtensions class

Different extension methods used in other EasyQuery classes.