C# Класс DataAccessFramework.Querying.SelectQuery

An object that represents an SQL select, containing references to the tables to join, and the where clauses.
Наследование: Query
Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
AddSelectField ( FieldReference field ) : void
AddSortExpression ( SortExpression sortExpression ) : void

Adds an expression to the data query describing how to sort the data.

AddTable ( TableBase table ) : void

Adds a table to the query.

AddWhere ( WherePart clause ) : void

Adds a where clause to the query.

All where clases added using this function must be true, i.e. there is an AND operator between them.

FindTable ( string tableName ) : TableBase

Finds the QueryTable instance previously added with a specific name.

SetAlias ( TableBase tableBase ) : void

Приватные методы

Метод Описание
GetAlias ( QueryTable table ) : string
Parse ( DataTool dataTool ) : ParseResult
WriteSelectedColumns ( StringBuilder builder ) : void

Описание методов

AddSelectField() публичный Метод

public AddSelectField ( FieldReference field ) : void
field FieldReference
Результат void

AddSortExpression() публичный Метод

Adds an expression to the data query describing how to sort the data.
public AddSortExpression ( SortExpression sortExpression ) : void
sortExpression SortExpression
Результат void

AddTable() публичный Метод

Adds a table to the query.
public AddTable ( TableBase table ) : void
table TableBase
Результат void

AddWhere() публичный Метод

Adds a where clause to the query.
All where clases added using this function must be true, i.e. there is an AND operator between them.
public AddWhere ( WherePart clause ) : void
clause WherePart
Результат void

FindTable() публичный Метод

Finds the QueryTable instance previously added with a specific name.
public FindTable ( string tableName ) : TableBase
tableName string
Результат TableBase

SetAlias() публичный Метод

public SetAlias ( TableBase tableBase ) : void
tableBase TableBase
Результат void