Метод | Описание | |
---|---|---|
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 |
protected IfNull ( StringBuilder builder, SqlExpression expr ) : void | ||
builder | StringBuilder | |
expr | SqlExpression | |
Результат | void |
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 |
public RenderRowCount ( SelectQuery query ) : string | ||
query | SelectQuery | Query definition to count rows for |
Результат | string |
public RenderSelect ( SelectQuery query ) : string | ||
query | SelectQuery | Query definition |
Результат | string |