dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteSelectStatement Class
Properties Methods

SQLiteSelectStatement Class Members

The following tables list the members exposed by SQLiteSelectStatement.

Public Constructors
 NameDescription
Public ConstructorCreates a new instance of the SQLiteSelectStatement class.  
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 or sets whether statement should request unique rows only. (Inherited from Devart.Common.SelectStatement)
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 or sets HAVING clause of the statement. (Inherited from Devart.Common.SelectStatement)
Public PropertyGets or sets the LIMIT clause for the 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 or sets WHERE clause of the statement. (Inherited from Devart.Common.SelectStatement)
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 MethodOverridden. Clears all parts of the SQLiteSelectStatement.  
Public Methodstatic (Shared in Visual Basic)Converts the specified SELECT statement to a SQLiteSelectStatement 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 SQLiteSelectStatement object.  
Top
See Also