C# Class DataAccessFramework.Querying.SelectQuery

An object that represents an SQL select, containing references to the tables to join, and the where clauses.
Inheritance: Query
显示文件 Open project: PeteProgrammer/DataAccessFramework Class Usage Examples

Public Methods

Method Description
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

Private Methods

Method Description
GetAlias ( QueryTable table ) : string
Parse ( DataTool dataTool ) : ParseResult
WriteSelectedColumns ( StringBuilder builder ) : void

Method Details

AddSelectField() public method

public AddSelectField ( FieldReference field ) : void
field FieldReference
return void

AddSortExpression() public method

Adds an expression to the data query describing how to sort the data.
public AddSortExpression ( SortExpression sortExpression ) : void
sortExpression SortExpression
return void

AddTable() public method

Adds a table to the query.
public AddTable ( TableBase table ) : void
table TableBase
return void

AddWhere() public method

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
return void

FindTable() public method

Finds the QueryTable instance previously added with a specific name.
public FindTable ( string tableName ) : TableBase
tableName string
return TableBase

SetAlias() public method

public SetAlias ( TableBase tableBase ) : void
tableBase TableBase
return void