C# Class Hd.QueryExtensions.Render.SqlServerRenderer

Renderer for SqlServer

Use SqlServerRenderer to render SQL statements for Microsoft SQL Server database. This version of Sql.Net has been tested with MSSQL 2000

Inheritance: SqlOmRenderer

Datei anzeigen Open project: TargetProcess/Tp.HelpDesk

Public Methods

Method	Description
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
SqlServerRenderer ( ) : System	Creates a new SqlServerRenderer

Protected Methods

Method	Description
IfNull ( StringBuilder builder, SqlExpression expr ) : void	Renders IfNull SqlExpression

Private Methods

Method	Description
RenderSelect ( SelectQuery query, bool renderOrderBy ) : string

Method Details

IfNull() protected method

Renders IfNull SqlExpression

protected IfNull ( StringBuilder builder, SqlExpression expr ) : void
builder	StringBuilder
expr	SqlExpression
return	void

RenderRowCount() public method

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
return	string

RenderSelect() public method

Renders a SELECT statement

public RenderSelect ( SelectQuery query ) : string
query	SelectQuery	Query definition
return	string

SqlServerRenderer() public method

Creates a new SqlServerRenderer

public SqlServerRenderer ( ) : System
return	System