Class SqlSyntaxProviderBase<TSyntax>

Represents the Base Sql Syntax provider implementation.

Inheritance

System.Object

Namespace: Umbraco.Cms.Infrastructure.Persistence.SqlSyntax

Assembly: cs.temp.dll.dll

Syntax

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

Type Parameters

Name	Description
TSyntax

Remarks

All Sql Syntax provider implementations should derive from this abstract class.

Constructors

SqlSyntaxProviderBase()

Declaration

protected SqlSyntaxProviderBase()

Properties

AddColumn

Declaration

public virtual string AddColumn { get; }

Property Value

Type	Description
System.String

AliasRegex

Declaration

public Regex AliasRegex { get; }

Property Value

Type	Description
Regex

AlterColumn

Declaration

public virtual string AlterColumn { get; }

Property Value

Type	Description
System.String

AlterSchema

Declaration

public virtual string AlterSchema { get; }

Property Value

Type	Description
System.String

AutoIncrementDefinition

Declaration

public string AutoIncrementDefinition { get; protected set; }

Property Value

Type	Description
System.String

BlobColumnDefinition

Declaration

public string BlobColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

BoolColumnDefinition

Declaration

public string BoolColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

ClauseOrder

Declaration

protected IList<Func<ColumnDefinition, string>> ClauseOrder { get; }

Property Value

Type	Description
System.Collections.Generic.IList<System.Func<ColumnDefinition, System.String>>

ConvertDateToOrderableString

Declaration

public virtual string ConvertDateToOrderableString { get; }

Property Value

Type	Description
System.String

ConvertDecimalToOrderableString

Declaration

public virtual string ConvertDecimalToOrderableString { get; }

Property Value

Type	Description
System.String

ConvertIntegerToOrderableString

Declaration

public virtual string ConvertIntegerToOrderableString { get; }

Property Value

Type	Description
System.String

CreateConstraint

Declaration

public virtual string CreateConstraint { get; }

Property Value

Type	Description
System.String

CreateDefaultConstraint

Declaration

public virtual string CreateDefaultConstraint { get; }

Property Value

Type	Description
System.String

CreateForeignKeyConstraint

Declaration

public virtual string CreateForeignKeyConstraint { get; }

Property Value

Type	Description
System.String

CreateIndex

Declaration

public virtual string CreateIndex { get; }

Property Value

Type	Description
System.String

CreateSchema

Declaration

public virtual string CreateSchema { get; }

Property Value

Type	Description
System.String

CreateTable

Declaration

public virtual string CreateTable { get; }

Property Value

Type	Description
System.String

DateTimeColumnDefinition

Declaration

public string DateTimeColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

DateTimeOffsetColumnDefinition

Declaration

public string DateTimeOffsetColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

DbProvider

Declaration

public abstract string DbProvider { get; }

Property Value

Type	Description
System.String

DbTypeMap

Declaration

protected DbTypes DbTypeMap { get; }

Property Value

Type	Description
DbTypes

DecimalColumnDefinition

Declaration

public string DecimalColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

DecimalColumnDefinitionFormat

Declaration

public string DecimalColumnDefinitionFormat { get; }

Property Value

Type	Description
System.String

DefaultDecimalPrecision

Declaration

public int DefaultDecimalPrecision { get; }

Property Value

Type	Description
System.Int32

DefaultDecimalScale

Declaration

public int DefaultDecimalScale { get; }

Property Value

Type	Description
System.Int32

DefaultIsolationLevel

Declaration

public abstract IsolationLevel DefaultIsolationLevel { get; }

Property Value

Type	Description
IsolationLevel

DefaultStringLength

Declaration

public int DefaultStringLength { get; }

Property Value

Type	Description
System.Int32

DefaultValueFormat

Declaration

public string DefaultValueFormat { get; }

Property Value

Type	Description
System.String

DeleteConstraint

Declaration

public virtual string DeleteConstraint { get; }

Property Value

Type	Description
System.String

DeleteData

Declaration

public virtual string DeleteData { get; }

Property Value

Type	Description
System.String

DeleteDefaultConstraint

Declaration

public virtual string DeleteDefaultConstraint { get; }

Property Value

Type	Description
System.String

DropColumn

Declaration

public virtual string DropColumn { get; }

Property Value

Type	Description
System.String

DropIndex

Declaration

public virtual string DropIndex { get; }

Property Value

Type	Description
System.String

DropSchema

Declaration

public virtual string DropSchema { get; }

Property Value

Type	Description
System.String

DropTable

Declaration

public virtual string DropTable { get; }

Property Value

Type	Description
System.String

GuidColumnDefinition

Declaration

public string GuidColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

InsertData

Declaration

public virtual string InsertData { get; }

Property Value

Type	Description
System.String

IntColumnDefinition

Declaration

public string IntColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

LongColumnDefinition

Declaration

public string LongColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

ProviderName

Declaration

public abstract string ProviderName { get; }

Property Value

Type	Description
System.String

RealColumnDefinition

Declaration

public string RealColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

RenameColumn

Declaration

public virtual string RenameColumn { get; }

Property Value

Type	Description
System.String

RenameTable

Declaration

public virtual string RenameTable { get; }

Property Value

Type	Description
System.String

StringColumnDefinition

Declaration

public string StringColumnDefinition { get; }

Property Value

Type	Description
System.String

StringLengthColumnDefinitionFormat

Declaration

public string StringLengthColumnDefinitionFormat { get; }

Property Value

Type	Description
System.String

StringLengthNonUnicodeColumnDefinitionFormat

Declaration

public string StringLengthNonUnicodeColumnDefinitionFormat { get; }

Property Value

Type	Description
System.String

StringLengthUnicodeColumnDefinitionFormat

Declaration

public string StringLengthUnicodeColumnDefinitionFormat { get; }

Property Value

Type	Description
System.String

TimeColumnDefinition

Declaration

public string TimeColumnDefinition { get; protected set; }

Property Value

Type	Description
System.String

TruncateTable

Declaration

public virtual string TruncateTable { get; }

Property Value

Type	Description
System.String

UpdateData

Declaration

public virtual string UpdateData { get; }

Property Value

Type	Description
System.String

Methods

DoesTableExist(IDatabase, String)

Declaration

public virtual bool DoesTableExist(IDatabase db, string tableName)

Parameters

Type	Name	Description
IDatabase	db
System.String	tableName

Returns

Type	Description
System.Boolean

EscapeString(String)

Declaration

public virtual string EscapeString(string val)

Parameters

Type	Name	Description
System.String	val

Returns

Type	Description
System.String

Format(ColumnDefinition)

Declaration

public virtual string Format(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

Format(ColumnDefinition, String, out IEnumerable<String>)

Declaration

public virtual string Format(ColumnDefinition column, string tableName, out IEnumerable<string> sqls)

Parameters

Type	Name	Description
ColumnDefinition	column
System.String	tableName
System.Collections.Generic.IEnumerable<System.String>	sqls

Returns

Type	Description
System.String

Format(ForeignKeyDefinition)

Declaration

public virtual string Format(ForeignKeyDefinition foreignKey)

Parameters

Type	Name	Description
ForeignKeyDefinition	foreignKey

Returns

Type	Description
System.String

Format(IndexDefinition)

Declaration

public virtual string Format(IndexDefinition index)

Parameters

Type	Name	Description
IndexDefinition	index

Returns

Type	Description
System.String

Format(IEnumerable<ColumnDefinition>)

Declaration

public virtual string Format(IEnumerable<ColumnDefinition> columns)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<ColumnDefinition>	columns

Returns

Type	Description
System.String

Format(IEnumerable<ForeignKeyDefinition>)

Declaration

public virtual List<string> Format(IEnumerable<ForeignKeyDefinition> foreignKeys)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<ForeignKeyDefinition>	foreignKeys

Returns

Type	Description
System.Collections.Generic.List<System.String>

Format(IEnumerable<IndexDefinition>)

Declaration

public virtual List<string> Format(IEnumerable<IndexDefinition> indexes)

Parameters

Type	Name	Description
System.Collections.Generic.IEnumerable<IndexDefinition>	indexes

Returns

Type	Description
System.Collections.Generic.List<System.String>

Format(TableDefinition)

Declaration

public virtual string Format(TableDefinition table)

Parameters

Type	Name	Description
TableDefinition	table

Returns

Type	Description
System.String

FormatCascade(String, Rule)

Declaration

protected virtual string FormatCascade(string onWhat, Rule rule)

Parameters

Type	Name	Description
System.String	onWhat
Rule	rule

Returns

Type	Description
System.String

FormatColumnRename(String, String, String)

Declaration

public virtual string FormatColumnRename(string tableName, string oldName, string newName)

Parameters

Type	Name	Description
System.String	tableName
System.String	oldName
System.String	newName

Returns

Type	Description
System.String

FormatConstraint(ColumnDefinition)

Declaration

protected virtual string FormatConstraint(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatDateTime(DateTime, Boolean)

This is used ONLY if we need to format datetime without using SQL parameters (i.e. during migrations)

Declaration

public virtual string FormatDateTime(DateTime date, bool includeTime = true)

Parameters

Type	Name	Description
System.DateTime	date
System.Boolean	includeTime

Returns

Type	Description
System.String

Remarks

MSSQL has a DateTime standard that is unambiguous and works on all servers: YYYYMMDD HH:mm:ss

FormatDefaultValue(ColumnDefinition)

Declaration

protected virtual string FormatDefaultValue(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatIdentity(ColumnDefinition)

Declaration

protected abstract string FormatIdentity(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatNullable(ColumnDefinition)

Declaration

protected virtual string FormatNullable(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatPrimaryKey(ColumnDefinition)

Declaration

protected virtual string FormatPrimaryKey(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatPrimaryKey(TableDefinition)

Declaration

public virtual string FormatPrimaryKey(TableDefinition table)

Parameters

Type	Name	Description
TableDefinition	table

Returns

Type	Description
System.String

FormatString(ColumnDefinition)

Declaration

protected virtual string FormatString(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

FormatSystemMethods(SystemMethods)

Declaration

protected abstract string FormatSystemMethods(SystemMethods systemMethod)

Parameters

Type	Name	Description
SystemMethods	systemMethod

Returns

Type	Description
System.String

FormatTableRename(String, String)

Declaration

public virtual string FormatTableRename(string oldName, string newName)

Parameters

Type	Name	Description
System.String	oldName
System.String	newName

Returns

Type	Description
System.String

FormatType(ColumnDefinition)

Declaration

protected virtual string FormatType(ColumnDefinition column)

Parameters

Type	Name	Description
ColumnDefinition	column

Returns

Type	Description
System.String

GetColumnsInSchema(IDatabase)

Declaration

public virtual IEnumerable<ColumnInfo> GetColumnsInSchema(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

Type	Description
System.Collections.Generic.IEnumerable<ColumnInfo>

GetConcat(String[])

Declaration

public virtual string GetConcat(params string[] args)

Parameters

Type	Name	Description
System.String[]	args

Returns

Type	Description
System.String

GetConstraintsPerColumn(IDatabase)

Declaration

public virtual IEnumerable<Tuple<string, string, string>> GetConstraintsPerColumn(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String, System.String>>

GetConstraintsPerTable(IDatabase)

Declaration

public virtual IEnumerable<Tuple<string, string>> GetConstraintsPerTable(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String>>

GetDefinedIndexes(IDatabase)

Declaration

public abstract IEnumerable<Tuple<string, string, string, bool>> GetDefinedIndexes(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String, System.String, System.Boolean>>

GetIndexType(IndexTypes)

Declaration

public virtual string GetIndexType(IndexTypes indexTypes)

Parameters

Type	Name	Description
IndexTypes	indexTypes

Returns

Type	Description
System.String

GetQuotedColumnName(String)

Declaration

public virtual string GetQuotedColumnName(string columnName)

Parameters

Type	Name	Description
System.String	columnName

Returns

Type	Description
System.String

GetQuotedName(String)

Declaration

public virtual string GetQuotedName(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
System.String

GetQuotedTableName(String)

Declaration

public virtual string GetQuotedTableName(string tableName)

Parameters

Type	Name	Description
System.String	tableName

Returns

Type	Description
System.String

GetQuotedValue(String)

Declaration

public virtual string GetQuotedValue(string value)

Parameters

Type	Name	Description
System.String	value

Returns

Type	Description
System.String

GetSpecialDbType(SpecialDbType)

Declaration

public virtual string GetSpecialDbType(SpecialDbType dbType)

Parameters

Type	Name	Description
SpecialDbType	dbType

Returns

Type	Description
System.String

GetStringColumnEqualComparison(String, Int32, TextColumnType)

Declaration

public virtual 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 virtual 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

GetTablesInSchema(IDatabase)

Declaration

public virtual IEnumerable<string> GetTablesInSchema(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

Type	Description
System.Collections.Generic.IEnumerable<System.String>

GetWildcardPlaceholder()

Declaration

public string GetWildcardPlaceholder()

Returns

Type	Description
System.String

ReadLock(IDatabase, Int32[])

Declaration

public abstract void ReadLock(IDatabase db, params int[] lockIds)

Parameters

Type	Name	Description
IDatabase	db
System.Int32[]	lockIds

ReadLock(IDatabase, TimeSpan, Int32)

Declaration

public abstract void ReadLock(IDatabase db, TimeSpan timeout, int lockId)

Parameters

Type	Name	Description
IDatabase	db
System.TimeSpan	timeout
System.Int32	lockId

SelectTop(Sql<ISqlContext>, Int32)

Declaration

public abstract Sql<ISqlContext> SelectTop(Sql<ISqlContext> sql, int top)

Parameters

Type	Name	Description
Sql<ISqlContext>	sql
System.Int32	top

Returns

Type	Description
Sql<ISqlContext>

SupportsClustered()

Declaration

public virtual bool SupportsClustered()

Returns

Type	Description
System.Boolean

SupportsIdentityInsert()

Declaration

public virtual bool SupportsIdentityInsert()

Returns

Type	Description
System.Boolean

TryGetDefaultConstraint(IDatabase, String, String, out String)

Declaration

public abstract bool TryGetDefaultConstraint(IDatabase db, string tableName, string columnName, out string constraintName)

Parameters

Type	Name	Description
IDatabase	db
System.String	tableName
System.String	columnName
System.String	constraintName

Returns

Type	Description
System.Boolean

WriteLock(IDatabase, Int32[])

Declaration

public abstract void WriteLock(IDatabase db, params int[] lockIds)

Parameters

Type	Name	Description
IDatabase	db
System.Int32[]	lockIds

WriteLock(IDatabase, TimeSpan, Int32)

Declaration

public abstract void WriteLock(IDatabase db, TimeSpan timeout, int lockId)

Parameters

Type	Name	Description
IDatabase	db
System.TimeSpan	timeout
System.Int32	lockId