C# Class SqlFu.Providers.SqlServer.SqlServer2012Provider

SQlServer 2012+

Inheritance: DbProvider

Show file Open project: sapiens/SqlFu Class Usage Examples

Public Properties

Property	Type	Description
DbTypes	SqlServerType

Public Methods

Method	Description
AddReturnInsertValue ( string sqlValues, string identityColumn ) : string
FormatIndexOptions ( string idxDef, string options = "" ) : string
FormatQueryPagination ( string sql, Pagination page, ParametersManager pm ) : string
GetColumnType ( Type type ) : string
GetIdentityKeyword ( ) : string
IsDbBusy ( DbException ex ) : bool
IsUniqueViolation ( DbException ex, string keyName = "" ) : bool
ObjectExists ( DbException ex, string name = null ) : bool
SetupParameter ( DbParameter param, string name, object value ) : void
SqlServer2012Provider ( Func factory ) : System

Protected Methods

Method	Description
GetEscapeIdentifierChars ( ) : EscapeIdentifierChars
InitTools ( ) : IDatabaseTools

Private Methods

Method	Description
FormatIdx ( string idxDef, string options, string before ) : string

Method Details

AddReturnInsertValue() public method

public AddReturnInsertValue ( string sqlValues, string identityColumn ) : string
sqlValues	string
identityColumn	string
return	string

FormatIndexOptions() public method

public FormatIndexOptions ( string idxDef, string options = "" ) : string
idxDef	string
options	string
return	string

FormatQueryPagination() public method

public FormatQueryPagination ( string sql, Pagination page, ParametersManager pm ) : string
sql	string
page	Pagination
pm	SqlFu.Builders.ParametersManager
return	string

GetColumnType() public method

public GetColumnType ( Type type ) : string
type	System.Type
return	string

GetEscapeIdentifierChars() protected method

protected GetEscapeIdentifierChars ( ) : EscapeIdentifierChars
return	EscapeIdentifierChars

GetIdentityKeyword() public method

public GetIdentityKeyword ( ) : string
return	string

InitTools() protected method

protected InitTools ( ) : IDatabaseTools
return	IDatabaseTools

IsDbBusy() public method

public IsDbBusy ( DbException ex ) : bool
ex	DbException
return	bool

IsUniqueViolation() public method

public IsUniqueViolation ( DbException ex, string keyName = "" ) : bool
ex	DbException
keyName	string
return	bool

ObjectExists() public method

public ObjectExists ( DbException ex, string name = null ) : bool
ex	DbException
name	string
return	bool

SetupParameter() public method

public SetupParameter ( DbParameter param, string name, object value ) : void
param	System.Data.Common.DbParameter
name	string
value	object
return	void

SqlServer2012Provider() public method

public SqlServer2012Provider ( Func factory ) : System
factory	Func
return	System

Property Details

DbTypes public property

public SqlServerType,SqlFu.Providers.SqlServer DbTypes
return	SqlServerType