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

Inheritance: IPreparable, ISerializable, ISqlFormattable
Afficher le fichier Open project: deveel/deveeldb Class Usage Examples

Méthodes publiques

Méthode 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

Private Methods

Méthode Description
CreateNewKey ( ) : String
FromClause ( SerializationInfo info, StreamingContext context ) : System
IPreparable ( IExpressionPreparer preparer ) : object
ISerializable ( SerializationInfo info, StreamingContext context ) : void
ISqlFormattable ( SqlStringBuilder builder ) : void

Method Details

AddSubQuery() public méthode

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.
Résultat void

AddSubQuery() public méthode

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.
Résultat void

AddTable() public méthode

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.
Résultat void

AddTable() public méthode

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.
Résultat void

AddTable() public méthode

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.
Résultat void

FromClause() public méthode

public FromClause ( ) : System
Résultat System

GetJoinPart() public méthode

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.
Résultat JoinPart

Join() public méthode

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.
Résultat void

ToString() public méthode

public ToString ( ) : string
Résultat string