C# Class Passive.Dialect.SqlServerDialect

Class that describes the dialect for Sql Server.

Inheritance: DatabaseDialect

Public Methods

Method	Description
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
return	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.
return	string

Initializes a new instance of the SqlServerDialect class.

public SqlServerDialect ( ) : System
return	System

Initializes a new instance of the SqlServerDialect class.

public SqlServerDialect ( int version ) : System
version	int	The version of the SQL server.
return	System