Class MicrosoftSqlSyntaxProviderBase<TSyntax>

Abstract class for defining MS sql implementations

Inheritance

System.Object

SqlSyntaxProviderBase<TSyntax>

Namespace: Umbraco.Cms.Infrastructure.Persistence.SqlSyntax

Assembly: cs.temp.dll.dll

Syntax

public abstract class MicrosoftSqlSyntaxProviderBase<TSyntax> : SqlSyntaxProviderBase<TSyntax>, ISqlSyntaxProvider where TSyntax : ISqlSyntaxProvider

Type Parameters

Name	Description
TSyntax

Constructors

MicrosoftSqlSyntaxProviderBase()

Declaration

protected MicrosoftSqlSyntaxProviderBase()

Properties

AddColumn

Declaration

public override string AddColumn { get; }

Property Value

Type	Description
System.String

RenameTable

Declaration

public override string RenameTable { get; }

Property Value

Type	Description
System.String

Methods

GetQuotedColumnName(String)

Declaration

public override string GetQuotedColumnName(string columnName)

Parameters

Type	Name	Description
System.String	columnName

Returns

Type	Description
System.String

GetQuotedName(String)

Declaration

public override string GetQuotedName(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

GetQuotedTableName(String)

Declaration

public override string GetQuotedTableName(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.String

GetSqlDbType(DbType)

Returns the mapped SqlDbType for the DbType specified

Declaration

public virtual SqlDbType GetSqlDbType(DbType dbType)

Parameters

Type	Name	Description
DbType	dbType

Returns

Type	Description
SqlDbType

GetSqlDbType(Type)

This uses a the DbTypeMap created and custom mapping to resolve the SqlDbType

Declaration

public virtual SqlDbType GetSqlDbType(Type clrType)

Parameters

Type	Name	Description
System.Type	clrType

Returns

Type	Description
SqlDbType

GetStringColumnEqualComparison(String, Int32, TextColumnType)

Declaration

public override string GetStringColumnEqualComparison(string column, int paramIndex, TextColumnType columnType)

Parameters

Type	Name	Description
System.String	column
System.Int32	paramIndex
TextColumnType	columnType

Returns

Type	Description
System.String

GetStringColumnWildcardComparison(String, Int32, TextColumnType)

Declaration

public override string GetStringColumnWildcardComparison(string column, int paramIndex, TextColumnType columnType)

Parameters

Type	Name	Description
System.String	column
System.Int32	paramIndex
TextColumnType	columnType

Returns

Type	Description
System.String