Show / Hide Table of Contents

Constructor DbSelectStatement

| Improve this Doc View Source

DbSelectStatement(Model, IReadOnlyList<ColumnMapping>, DbFromClause, DbExpression, IReadOnlyList<DbExpressionSort>, Int32, Int32)

Initializes a new instance of DbSelectStatement class.

Declaration
public DbSelectStatement(Model model, IReadOnlyList<ColumnMapping> select, DbFromClause from, DbExpression where, IReadOnlyList<DbExpressionSort> orderBy, int offset, int fetch)
Parameters
Type Name Description
Model model

The model of this query.

System.Collections.Generic.IReadOnlyList<ColumnMapping> select

The column mappings of the SELECT statement.

DbFromClause from

The FROM clause.

DbExpression where

The WHERE expression.

System.Collections.Generic.IReadOnlyList<DbExpressionSort> orderBy

The ORDER BY list.

System.Int32 offset

Specifies how many rows to skip within the query result.

System.Int32 fetch

Specifies how many rows to return in the query result.

| Improve this Doc View Source

DbSelectStatement(Model, IReadOnlyList<ColumnMapping>, DbFromClause, DbExpression, IReadOnlyList<DbExpression>, DbExpression, IReadOnlyList<DbExpressionSort>, Int32, Int32)

Initializes a new instance of DbSelectStatement class.

Declaration
public DbSelectStatement(Model model, IReadOnlyList<ColumnMapping> select, DbFromClause from, DbExpression where, IReadOnlyList<DbExpression> groupBy, DbExpression having, IReadOnlyList<DbExpressionSort> orderBy, int offset, int fetch)
Parameters
Type Name Description
Model model

The model of this query.

System.Collections.Generic.IReadOnlyList<ColumnMapping> select

The column mappings of the SELECT statement.

DbFromClause from

The FROM clause.

DbExpression where

The WHERE expression.

System.Collections.Generic.IReadOnlyList<DbExpression> groupBy

The GROUP BY list.

DbExpression having

The HAVING expression.

System.Collections.Generic.IReadOnlyList<DbExpressionSort> orderBy

The ORDER BY list.

System.Int32 offset

Specifies how many rows to skip within the query result.

System.Int32 fetch

Specifies how many rows to return in the query result.

  • Improve this Doc
  • View Source
Back to top Copyright © Weifen Luo | DevZest