C# Класс Hd.QueryExtensions.Render.OracleRenderer

Renderer for Oracle

Use OracleRenderer to render SQL statements for Oracle database. This version of Sql.Net has been tested with Oracle 9i.

Наследование: SqlOmRenderer

Показать файл Открыть проект

Открытые методы

Метод	Описание
OracleRenderer ( ) : System	Creates a new instance of OracleRenderer
RenderRowCount ( SelectQuery query ) : string	Renders a row count SELECT statement. Renders a SQL statement which returns a result set with one row and one cell which contains the number of rows query can generate. The generated statement will work nicely with System.Data.IDbCommand.ExecuteScalar method.
RenderSelect ( SelectQuery query ) : string	Renders a SELECT statement

Защищенные методы

Метод	Описание
BitwiseAnd ( StringBuilder builder, WhereTerm term ) : void	Renders bitwise and
IfNull ( StringBuilder builder, SqlExpression expr ) : void	Renders IfNull SqlExpression

Приватные методы

Метод	Описание
RenderSelect ( SelectQuery query, int limitRows ) : string

Описание методов

BitwiseAnd() защищенный Метод

Renders bitwise and

protected BitwiseAnd ( StringBuilder builder, WhereTerm term ) : void
builder	StringBuilder
term	WhereTerm
Результат	void

IfNull() защищенный Метод

Renders IfNull SqlExpression

protected IfNull ( StringBuilder builder, SqlExpression expr ) : void
builder	StringBuilder
expr	SqlExpression
Результат	void

OracleRenderer() публичный Метод

Creates a new instance of OracleRenderer

public OracleRenderer ( ) : System
Результат	System

RenderRowCount() публичный Метод

Renders a row count SELECT statement.

Renders a SQL statement which returns a result set with one row and one cell which contains the number of rows query can generate. The generated statement will work nicely with System.Data.IDbCommand.ExecuteScalar method.

public RenderRowCount ( SelectQuery query ) : string
query	SelectQuery	Query definition to count rows for
Результат	string

RenderSelect() публичный Метод

Renders a SELECT statement

public RenderSelect ( SelectQuery query ) : string
query	SelectQuery	Query definition
Результат	string