C# 클래스 Hd.QueryExtensions.Render.MySqlRenderer

Renderer for MySql

Use MySqlRenderer to render SQL statements for MySql database. This version of Sql.Net has been tested with MySql 4

상속: SqlOmRenderer

파일 보기 프로젝트 열기: TargetProcess/Tp.HelpDesk

공개 메소드들

메소드	설명
MySqlRenderer ( ) : System	Creates a new MySqlRenderer
RenderPage ( int pageIndex, int pageSize, int totalRowCount, SelectQuery query ) : string	Renders a SELECT statement which a result-set page Parameter totalRowCount is ignored.
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 MySql 4.1 does not support GroupByWithCube option. If a query has SelectQuery.GroupByWithCube set an InvalidQueryException exception will be thrown.

보호된 메소드들

메소드	설명
IfNull ( StringBuilder builder, SqlExpression expr ) : void	Renders IfNull SqlExpression

비공개 메소드들

메소드	설명
RenderSelect ( SelectQuery query, bool forRowCount, int offset, int limitRows ) : string

메소드 상세

IfNull() 보호된 메소드

Renders IfNull SqlExpression

protected IfNull ( StringBuilder builder, SqlExpression expr ) : void
builder	StringBuilder
expr	SqlExpression
리턴	void

MySqlRenderer() 공개 메소드

Creates a new MySqlRenderer

public MySqlRenderer ( ) : System
리턴	System

RenderPage() 공개 메소드

Renders a SELECT statement which a result-set page

Parameter totalRowCount is ignored.

public RenderPage ( int pageIndex, int pageSize, int totalRowCount, SelectQuery query ) : string
pageIndex	int	The zero based index of the page to be returned
pageSize	int	The size of a page
totalRowCount	int	Total number of rows the query would yeild if not paged
query	SelectQuery	Query definition to apply paging on
리턴	string

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

MySql 4.1 does not support GroupByWithCube option. If a query has SelectQuery.GroupByWithCube set an InvalidQueryException exception will be thrown.

public RenderSelect ( SelectQuery query ) : string
query	SelectQuery	Query definition
리턴	string