Korzh.EasyQuery.Db namespace

AutoLinker class

Gets or sets the progress indicator object. This property is used to show progress for some time consuming operations performed inside the model

ColumnAliasesUsage enum

Represents the conditions when the result SQL should include column aliases.

ColumnExtensions class

Gets a value indicating whether this column used the alias name or not.

ConditionSqlGeneratedEventArgs class

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

CustomSqlColumnDescriptor struct

Contains descriptor to create custom sql expression column

CustomSqlExpr class

Represents a custom SQL expression

DbConnectionLoaderOptions class

DbConnectionModelLoaderOptions class

Represents different options for [Korzh.EasyQuery.Services.DbConnectionModelLoader](api-reference/korzh-easyquery-db/korzh-easyquery-services-namespace/dbconnectionmodelloader-class) class

DbEntityAttr class

Base attribute of SQL entity

DbEntityAttrDescriptor class

DbEntityAttrXmlSerializer class

DbExprTag class

Contains several constants for db-related expressions tags values

DbFieldInfo class

Represents a structure that contains information about some table field

DbFieldInfoList class

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

DbGate class

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

DbGateException class

Represents exception class for [Korzh.EasyQuery.Db.DbGate](api-reference/korzh-easyquery-db/korzh-easyquery-db-namespace/dbgate-class)

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/korzh-easyquery-db/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/korzh-easyquery-db/korzh-easyquery-db-namespace/dblinkinfo-class) objects

DbModel class

Database-related implementation of [Korzh.EasyQuery.DataModel](api-reference/korzh-easyquery/korzh-easyquery-namespace/datamodel-class) class. In addition to the basic data it contains also list of database tables and the links between them.

DbModelExtensions class

Contains several DbModel extensions

DbModelXmlSerializer class

DbOperator class

Represents a logical expression or "predicate". For example: "less than", "is equal to", "starts with".

DbOperatorXmlSerializer class

DbParam class

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

DbParameters class

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

DbQuery class

Represents query for building SQL command

DbQueryBuilder class

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

DbTable class

Represents one table in [Korzh.EasyQuery.Db.DbModel](api-reference/korzh-easyquery-db/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/korzh-easyquery-db/korzh-easyquery-db-namespace/dbtableinfo-class) objects

DbTableXmlSerializer class

DbUtils class

Different utilties for database-oriented operations For internal use only

EOLSymbol enum

Represents the symbol (or symbols) which are used to separate lines in generated SQL statements

FilterExpression class

Represents the result of performing BuildSQL command.

FilterExpressionBuilder class

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

FormatType enum

Represents different database types

IConnectionStringBuilderDlg interface

Defines methods for ConnectionString Builder dialog

JoinsOrder enum

Represents differt types of table order in the FROM clause of generated SQL statement

LinkCondType enum

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

LoginRequestEventArgs class

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

OrderByStyles enum

Represents the way fields appear in ORDER BY clause

Path class

Represents list of tables which are linked to each other

PathList class

Represents list of paths.

ResultSetPortion class

Represents a portion of result set to return

ResultTableNode class

Represents one table in result SQL statement

SqlDialect class

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

SqlDialectList class

Represents different dialects of SQL

SqlExtras class

Represents different extra clauses of SELECT query.

SqlFormats class

Represents different formats of SQL statements.

SqlQueryBuilder class

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

SqlQueryBuilderExtensions class

Contains several extension method used in SqlQueryBulder (and, possibly, other query builders as well)

SqlStatement class

Represents the result of performing BuildSQL command.

Table class

Table class represents one table in a [Korzh.EasyQuery.Db.DbModel](api-reference/korzh-easyquery-db/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

TableLink.Condition class

Represents linking condition

TableLink.ConditionList class

Represents list of linking conditions

TableLinkList class

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

TableLinkStore class

Represents a storage of links connected with some DbModel object

TableLinkStoreException class

Class LinkStoreException. Implements the `System.Exception`

TableLinkType enum

Type of the link (inner, outer left, outer right or full)

TableLinkXmlSerializer class

TableList class

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

TableListException class

Class TableListException. Implements the `System.Exception`

TablePathFinder class

Contains logic for finding path between two tables

TableStore class

Represetns storage of tables.

TableXmlSerializer class

TableXmlSerializer class

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.

VirtualTableXmlSerializer class

XmlExtensions class

Different extension methods used in other EasyQuery classes.