dotConnect for SQL Server Documentation
Devart.Common Namespace / SelectStatement Class
Properties Methods

In This Topic
    SelectStatement Class Members
    In This Topic

    The following tables list the members exposed by SelectStatement.

    Public Properties
     NameDescription
    Public PropertyAllGets or sets the value, indicating if the all records are selected or only the unique ones.  
    Public PropertyColumnsContains list of columns and expressions used in the select-list of the current SelectStatement object.  
    Public PropertyDistinctGets or sets whether statement should request unique rows only.  
    Public PropertyGroupByContains list of columns used in the GROUP BY clause of the current SelectStatement object.  
    Public PropertyHavingGets or sets HAVING clause of the statement.  
    Public PropertyOrderByContains list of columns used in the ORDER BY clause of the current SelectStatement object.  
    Public PropertyTablesContains list of tables and subqueries used in the FROM clause of the current SelectStatement object.  
    Public PropertyWhereGets or sets WHERE clause of the statement.  
    Top
    Public Methods
     NameDescription
    Public MethodAddHavingConditionAdds new condition to HAVING clause of the statement, represented by the Having property.  
    Public MethodAddWhereConditionAdds new condition to WHERE clause of the statement, represented by the Where property.  
    Public MethodClearClears all parts of the SelectStatement.  
    Public MethodToStringReturns SQL statement in the text form.  
    Top
    See Also

    Reference

    SelectStatement Class
    Devart.Common Namespace

     

     

    © 2007 - 2024 Devart. All Rights Reserved.

    Send Feedback