C# 클래스 DataAccessFramework.Querying.SelectQuery

An object that represents an SQL select, containing references to the tables to join, and the where clauses.
상속: Query
파일 보기 프로젝트 열기: PeteProgrammer/DataAccessFramework 1 사용 예제들

공개 메소드들

메소드 설명
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