C# Класс Deveel.Data.Sql.Expressions.FromClause

Наследование: IPreparable, ISerializable, ISqlFormattable

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

Метод	Описание
AddSubQuery ( SqlQueryExpression subQuery ) : void	Adds a sub-query expression as source of the query.
AddSubQuery ( string alias, SqlQueryExpression subQuery ) : void	Adds a sub-query expression as source of the query.
AddTable ( string tableName ) : void	Adds a simple table reference as the source of the query.
AddTable ( string alias, FromTable table ) : void	Adds a table as source to the query with a given alias.
AddTable ( string alias, string tableName ) : void	Adds a simple table reference as the source of the query with a given alias.
FromClause ( ) : System
GetJoinPart ( int offset ) : JoinPart	Gets the descriptor of the join at the given offset.
Join ( JoinType joinType, SqlExpression onExpression ) : void	Sets a join between the last added table and the one that preceeds it.
ToString ( ) : string

Метод	Описание
CreateNewKey ( ) : String
FromClause ( SerializationInfo info, StreamingContext context ) : System
IPreparable ( IExpressionPreparer preparer ) : object
ISerializable ( SerializationInfo info, StreamingContext context ) : void
ISqlFormattable ( SqlStringBuilder builder ) : void

Adds a sub-query expression as source of the query.

public AddSubQuery ( SqlQueryExpression subQuery ) : void
subQuery	SqlQueryExpression	The sub-query expression as source of the query.
Результат	void

Adds a sub-query expression as source of the query.

public AddSubQuery ( string alias, SqlQueryExpression subQuery ) : void
alias	string	The unique alias name of the expression within the clause.
subQuery	SqlQueryExpression	The sub-query expression as source of the query.
Результат	void

Adds a simple table reference as the source of the query.

public AddTable ( string tableName ) : void
tableName	string	The name of the table in the database to query from.
Результат	void

Adds a table as source to the query with a given alias.

public AddTable ( string alias, FromTable table ) : void
alias	string	The unique name alias of the table source within the clause.
table	FromTable	The table source object to query from.
Результат	void

Adds a simple table reference as the source of the query with a given alias.

public AddTable ( string alias, string tableName ) : void
alias	string	The unique name alias of the table source within the clause.
tableName	string	The name of the table in the database to query from.
Результат	void

public FromClause ( ) : System
Результат	System

Gets the descriptor of the join at the given offset.

public GetJoinPart ( int offset ) : JoinPart
offset	int	The offset of the join descriptor to get.
Результат	JoinPart

Sets a join between the last added table and the one that preceeds it.

public Join ( JoinType joinType, SqlExpression onExpression ) : void
joinType	JoinType	The type of join to apply to the two tables.
onExpression	SqlExpression	The condition for the two tables to join.
Результат	void

public ToString ( ) : string
Результат	string