C# Class Deveel.Data.Sql.Expressions.FromClause

Inheritance: IPreparable, ISerializable, ISqlFormattable

Public Methods

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

Method	Description
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.
return	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.
return	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.
return	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.
return	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.
return	void

public FromClause ( ) : System
return	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.
return	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.
return	void

public ToString ( ) : string
return	string