dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlSelectStatement Class
Properties Methods

In This Topic
    SqlSelectStatement Class Members
    In This Topic

    The following tables list the members exposed by SqlSelectStatement.

    Public Constructors
     NameDescription
    Public ConstructorCreates and initializes new instance of SqlSelectStatement.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the value, indicating if the all records are selected or only the unique ones. (Inherited from Devart.Common.SelectStatement)
    Public PropertyContains list of columns and expressions used in the select-list of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyGets a COMPUTE BY clause of a SELECT statement.  
    Public PropertyGets or sets whether statement should request unique rows only. (Inherited from Devart.Common.SelectStatement)
    Public PropertyGets a SELECT FOR clause of a SELECT statement.  
    Public PropertyContains list of columns used in the GROUP BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyGets GROUP BY clause parameters of a SELECT statement.  
    Public PropertyOverridden. Gets or sets HAVING clause of the statement.  
    Public PropertyGets or sets OPTIONS clause of a SELECT statement.  
    Public PropertyContains list of columns used in the ORDER BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyContains list of tables and subqueries used in the FROM clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyGets a TOP clause of a SELECT statement.  
    Public PropertyOverridden. Gets or sets WHERE clause of the statement.  
    Top
    Public Methods
     NameDescription
    Public MethodAdds new condition to HAVING clause of the statement, represented by the Having property. (Inherited from Devart.Common.SelectStatement)
    Public MethodAdds new condition to WHERE clause of the statement, represented by the Where property. (Inherited from Devart.Common.SelectStatement)
    Public MethodClears all parts of the Devart.Common.SelectStatement. (Inherited from Devart.Common.SelectStatement)
    Public Methodstatic (Shared in Visual Basic)Overloaded. Converts the specified SELECT statement to a SqlSelectStatement object.  
    Public MethodReturns SQL statement in the text form. (Inherited from Devart.Common.SelectStatement)
    Public Methodstatic (Shared in Visual Basic)Tries to convert the specified SELECT statement to a SqlSelectStatement object.  
    Top
    See Also