dotConnect for PostgreSQL Documentation
Devart.Data.PostgreSql Namespace / PgSqlSelectStatement Class
Properties Methods

In This Topic
    PgSqlSelectStatement Class Members
    In This Topic

    The following tables list the members exposed by PgSqlSelectStatement.

    Public Constructors
     NameDescription
    Public ConstructorPgSqlSelectStatement ConstructorCreates a new instance of the PgSqlSelectStatement class.  
    Top
    Public Properties
     NameDescription
    Public PropertyAllGets or sets the value, indicating if the all records are selected or only the unique ones. (Inherited from Devart.Common.SelectStatement)
    Public PropertyColumnsContains list of columns and expressions used in the select-list of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyDistinctGets or sets whether statement should request unique rows only. (Inherited from Devart.Common.SelectStatement)
    Public PropertyGroupByContains list of columns used in the GROUP BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyHavingGets or sets HAVING clause of the statement. (Inherited from Devart.Common.SelectStatement)
    Public PropertyLimitGets or sets the LIMIT clause for the statement.  
    Public PropertyOrderByContains list of columns used in the ORDER BY clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyTablesContains list of tables and subqueries used in the FROM clause of the current Devart.Common.SelectStatement object. (Inherited from Devart.Common.SelectStatement)
    Public PropertyWhereGets or sets WHERE clause of the statement. (Inherited from Devart.Common.SelectStatement)
    Top
    Public Methods
     NameDescription
    Public MethodAddHavingConditionAdds new condition to HAVING clause of the statement, represented by the Having property. (Inherited from Devart.Common.SelectStatement)
    Public MethodAddWhereConditionAdds new condition to WHERE clause of the statement, represented by the Where property. (Inherited from Devart.Common.SelectStatement)
    Public MethodClearOverridden. Clears all parts of the PgSqlSelectStatement.  
    Public Methodstatic (Shared in Visual Basic)ParseConverts the specified SELECT statement to a PgSqlSelectStatement object.  
    Public MethodToStringReturns SQL statement in the text form. (Inherited from Devart.Common.SelectStatement)
    Public Methodstatic (Shared in Visual Basic)TryParseTries to convert the specified SELECT statement to a PgSqlSelectStatement object.  
    Top
    See Also

    Reference

    PgSqlSelectStatement Class
    Devart.Data.PostgreSql Namespace

     

     

    © 2003 - 2024 Devart. All Rights Reserved.

    Send Feedback