View Source

Class MicrosoftSqlSyntaxProviderBase<TSyntax>

Abstract class for defining MS sql implementations

Inheritance
System.Object
SqlSyntaxProviderBase<TSyntax>
Namespace: Umbraco.Cms.Persistence.SqlServer.Services
Assembly: Umbraco.Cms.Persistence.SqlServer.dll
Syntax
public abstract class MicrosoftSqlSyntaxProviderBase<TSyntax> : SqlSyntaxProviderBase<TSyntax>, ISqlSyntaxProvider where TSyntax : ISqlSyntaxProvider
Type Parameters
Name Description
TSyntax

Constructors

View Source

MicrosoftSqlSyntaxProviderBase()

Declaration
protected MicrosoftSqlSyntaxProviderBase()

Properties

View Source

AddColumn

Declaration
public override string AddColumn { get; }
Property Value
Type Description
System.String
View Source

RenameTable

Declaration
public override string RenameTable { get; }
Property Value
Type Description
System.String

Methods

View Source

GetQuotedColumnName(String)

Declaration
public override string GetQuotedColumnName(string columnName)
Parameters
Type Name Description
System.String columnName
Returns
Type Description
System.String
View Source

GetQuotedName(String)

Declaration
public override string GetQuotedName(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
System.String
View Source

GetQuotedTableName(String)

Declaration
public override string GetQuotedTableName(string tableName)
Parameters
Type Name Description
System.String tableName
Returns
Type Description
System.String
View Source

GetSqlDbType(DbType)

Returns the mapped SqlDbType for the DbType specified

Declaration
public virtual SqlDbType GetSqlDbType(DbType dbType)
Parameters
Type Name Description
System.Data.DbType dbType
Returns
Type Description
System.Data.SqlDbType
View Source

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
Type clrType
Returns
Type Description
System.Data.SqlDbType
View Source

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
View Source

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
View Source

HandleCreateTable(IDatabase, TableDefinition, Boolean)

Declaration
public override void HandleCreateTable(IDatabase database, TableDefinition tableDefinition, bool skipKeysAndIndexes = false)
Parameters
Type Name Description
IDatabase database
TableDefinition tableDefinition
System.Boolean skipKeysAndIndexes