C# Класс Passive.Dialect.SqlServerDialect

Class that describes the dialect for Sql Server.

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

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

Метод	Описание
GetIdentitySql ( ) : string	Gets the SQL for retrieving the just-inserted identity.
GetPagingSql ( string tableName, string columns, string orderBy, string where, int pageSize, int currentPage ) : string	Gets the SQL statement for paging given the supplied information.
SqlServerDialect ( ) : System	Initializes a new instance of the SqlServerDialect class.
SqlServerDialect ( int version ) : System	Initializes a new instance of the SqlServerDialect class.

Gets the SQL for retrieving the just-inserted identity.

public GetIdentitySql ( ) : string
Результат	string

Gets the SQL statement for paging given the supplied information.

public GetPagingSql ( string tableName, string columns, string orderBy, string where, int pageSize, int currentPage ) : string
tableName	string	Name of the table.
columns	string	The columns.
orderBy	string	The order by.
where	string	The where.
pageSize	int	Size of the page.
currentPage	int	The current page.
Результат	string

Initializes a new instance of the SqlServerDialect class.

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

Initializes a new instance of the SqlServerDialect class.

public SqlServerDialect ( int version ) : System
version	int	The version of the SQL server.
Результат	System