C1.DataConnector.SelectStatement

SelectStatement Class

A class representing a SQL select statement

SelectStatement

public class SelectStatement : ISQLStatement

Name	Description
SelectStatement()

Name	Description
Columns	An IList of the selected columns represented as ColumnExpression
CompoundStatements	An IList containing the compound select statements
Groupby	The Group-by clause of this select statement
IsCompound	Boolean to check whether or not this select statement is a compound select statement
IsDistinct	IsDistinct
IsJoin	Boolean to check if this SelectStatement contains join tables
JoinTables	The list of the tables that are used as Join tables
Limit	The Limit expressed for this SelectStatement
Offset	The Offset expressed for this SelectStatement
Orderby	The Order-by clause of this select statement
TableOrSubquery	The table or the sub-query that appears as the source table for this query(SQL FROM clause)
Top	Top
Type	The type of the SQL statement
Where	The Where clause of this select statement