C# Class SqlFu.Providers.SqlServer.SqlServer2012Provider

SQlServer 2012+
Inheritance: DbProvider
Exibir arquivo 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_oe property

public SqlServerType,SqlFu.Providers.SqlServer DbTypes
return SqlServerType