Class DbSelectStatement
Represents SQL SELECT statement.
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: DevZest.Data.Primitives
Assembly: DevZest.Data.dll
Syntax
public sealed class DbSelectStatement : DbQueryStatementConstructors
| Name | Description |
|---|---|
| DbSelectStatement(Model, IReadOnlyList<ColumnMapping>, DbFromClause, DbExpression, IReadOnlyList<DbExpression>, DbExpression, IReadOnlyList<DbExpressionSort>, Int32, Int32) | Initializes a new instance of DbSelectStatement class. |
| DbSelectStatement(Model, IReadOnlyList<ColumnMapping>, DbFromClause, DbExpression, IReadOnlyList<DbExpressionSort>, Int32, Int32) | Initializes a new instance of DbSelectStatement class. |
Properties
| Name | Description |
|---|---|
| Fetch | Gets avalue that specifies how many rows to return in the query result. |
| From | Gets the FROM clause. |
| GroupBy | Gets the GROUP BY list. |
| Having | Gets the HAVING expression. |
| IsAggregate | Gets a value indicating whether this is an aggregate query. |
| IsSimple | Gets a value indicating whether this is a simple query. |
| Offset | Gets a value that specifies how many rows to skip within the query result. |
| OrderBy | Gets the ORDER BY list. |
| Select | Gets the column mappings of the SELECT statement. |
| Where | Gets the WHERE expression. |
Methods
| Name | Description |
|---|---|
| Accept(DbFromClauseVisitor) | |
| Accept<T>(DbFromClauseVisitor<T>) | |
| BuildToTempTableStatement() | |
| GetSequentialKeySelectStatement(SequentialKey) |