Kpok Patagon Framework

SelectStatement

SelectStatement allows the construction of SQL SELECT statements.

Namespace:
KpokPatagon.Data.Query
Type:
Class
Public:
Yes
Protected:
No
Sealed:
No
Abstract:
No
Inherits from:
KpokPatagon.Data.Query.Statement

Constructors

SelectStatement

Default constructor

Signature:
public Void SelectStatement()

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(service)
Parameters
Name Type Summary
service IDataService The IDataService from which the statement will be based on.

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(service, useAlias)
Parameters
Name Type Summary
service IDataService The IDataService from which the statement will be based on.
useAlias Boolean Indicates whether to use the Alias to build the command.
Exceptions
Type Summary
ArgumentNullException Thrown when service is null.

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(repository)
Parameters
Name Type Summary
repository Repository The underlying repository

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(repository, useAlias)
Parameters
Name Type Summary
repository Repository The underlying repository
useAlias Boolean Indicates whether to use the Alias to build the command.

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(name, repository)
Parameters
Name Type Summary
name String The name of the statement
repository Repository The underlying repository

SelectStatement

Initializes a new instance of SelectStatement.

Signature:
public Void SelectStatement(name, repository, useAlias)
Parameters
Name Type Summary
name String The name of the statement
repository Repository The underlying repository
useAlias Boolean Indicates whether to use the Alias to build the command.

Properties

Columns

List of SELECT statement Columns.

Signature:
public IList<IColumn> Columns { get; }

GroupColumns

List of Columns for the GROUP BY clause.

Signature:
public IList<Column> GroupColumns { get; }

HavingConditions

List of SearchConditions that conforms the HAVING clause.

Signature:
public IList<SearchCondition> HavingConditions { get; }

IndexHint

The name of the index to be used by the engine when executing this query.

Signature:
public String IndexHint { get; set; }

IsPagingRequested

Whether paging is requested.

Signature:
public Boolean IsPagingRequested { get; }

Modifiers

List of Modifiers for the SELECT statement.

Signature:
public IList<Modifier> Modifiers { get; }

OrderColumns

List of OrderColumns for the ORDER BY clause.

Signature:
public IList<OrderColumn> OrderColumns { get; }

Page

Number of the page of data to select. Default is zero which means no paging.

Signature:
public Int32 Page { get; set; }

PageLength

Page length for building a SELECT that returns a page of data. Default is zero which means no paging.

Signature:
public Int32 PageLength { get; set; }

Relations

List of Relations for the SELECT statement.

Signature:
public IList<Relation> Relations { get; }

In this document