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

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

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

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

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

public AddSortExpression ( SortExpression sortExpression ) : void
sortExpression	SortExpression
return	void

Adds a table to the query.

public AddTable ( TableBase table ) : void
table	TableBase
return	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.

public AddWhere ( WherePart clause ) : void
clause	WherePart
return	void

Finds the QueryTable instance previously added with a specific name.

public FindTable ( string tableName ) : TableBase
tableName	string
return	TableBase

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