Skip to main content

SelectStatement Members

Represents the select statement.

Constructors

Name Description
SelectStatement() Initializes a new instance of the SelectStatement class.
SelectStatement(DBTable, String) Initializes a new instance of the SelectStatement class with the specified settings.

Fields

Name Description
Alias A String value that identifies the table. Inherited from JoinNode.
Condition Specifies the criteria expression. Inherited from JoinNode.
GroupCondition Specifies the grouping expression that is represented by a CriteriaOperator descendant.
Operands The collection of operands. Inherited from BaseStatement.
SkipSelectedRecords Specifies the number of records to exclude from the query result.
SubNodes Provides access to the collection of sub nodes that is represented by a JoinNodeCollection object. Inherited from JoinNode.
Table Inherited from JoinNode.
TopSelectedRecords Specifies the maximum number of selected records.
Type A JoinType enumeration value that specifies the join’s type. Inherited from JoinNode.

Properties

Name Description
GroupProperties Provides access to the CriteriaOperatorCollection that specifies the columns by which the result of the current SelectStatement should be grouped.
SortProperties Provides access to the QuerySortingCollection collection.

Methods

Name Description
CollectJoinNodesAndCriteria(out List<JoinNode>, out List<CriteriaOperator>) Inherited from JoinNode.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the current object has the same settings as the specified object.
GetColumn(String) Returns the column with the specified name. Inherited from JoinNode.
GetHashCode() Gets the hash code (a number) that corresponds to the value of the current SelectStatement object.
GetTablesColumns(BaseStatement[]) static This member supports the internal infrastructure and is not intended to be used directly from your code. Inherited from BaseStatement.
GetTablesNames() Returns the names of the tables that are referenced in the statement. Inherited from BaseStatement.
GetTablesNames(BaseStatement[]) static Returns the names of the tables that are referenced in the specified statements. Inherited from BaseStatement.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object.
See Also