View Source

Class SqlServerSyntaxProvider

Represents an SqlSyntaxProvider for Sql Server.

Inheritance
System.Object
SqlSyntaxProviderBase<SqlServerSyntaxProvider>
MicrosoftSqlSyntaxProviderBase<SqlServerSyntaxProvider>
Namespace: Umbraco.Cms.Persistence.SqlServer.Services
Assembly: Umbraco.Cms.Persistence.SqlServer.dll
Syntax
public class SqlServerSyntaxProvider : MicrosoftSqlSyntaxProviderBase<SqlServerSyntaxProvider>, ISqlSyntaxProvider

Constructors

View Source

SqlServerSyntaxProvider(IOptions<GlobalSettings>)

Declaration
public SqlServerSyntaxProvider(IOptions<GlobalSettings> globalSettings)
Parameters
Type Name Description
IOptions<GlobalSettings> globalSettings
View Source

SqlServerSyntaxProvider(IOptions<GlobalSettings>, ILogger<SqlServerSyntaxProvider>)

Declaration
public SqlServerSyntaxProvider(IOptions<GlobalSettings> globalSettings, ILogger<SqlServerSyntaxProvider> logger)
Parameters
Type Name Description
IOptions<GlobalSettings> globalSettings
ILogger<SqlServerSyntaxProvider> logger

Properties

View Source

CreateIndex

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

DbProvider

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

DefaultIsolationLevel

Declaration
public override IsolationLevel DefaultIsolationLevel { get; }
Property Value
Type Description
System.Data.IsolationLevel
View Source

DeleteDefaultConstraint

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

DropIndex

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

ProviderName

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

RenameColumn

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

ServerVersion

Declaration
public SqlServerSyntaxProvider.ServerVersionInfo ServerVersion { get; }
Property Value
Type Description
SqlServerSyntaxProvider.ServerVersionInfo

Methods

View Source

AppendForUpdateHint(Sql<ISqlContext>)

Declaration
public override Sql<ISqlContext> AppendForUpdateHint(Sql<ISqlContext> sql)
Parameters
Type Name Description
Sql<ISqlContext> sql
Returns
Type Description
Sql<ISqlContext>
View Source

DoesPrimaryKeyExist(IDatabase, String, String)

Declaration
public override bool DoesPrimaryKeyExist(IDatabase db, string tableName, string primaryKeyName)
Parameters
Type Name Description
IDatabase db
System.String tableName
System.String primaryKeyName
Returns
Type Description
System.Boolean
View Source

DoesTableExist(IDatabase, String)

Declaration
public override bool DoesTableExist(IDatabase db, string tableName)
Parameters
Type Name Description
IDatabase db
System.String tableName
Returns
Type Description
System.Boolean
View Source

Format(IndexDefinition)

Declaration
public override string Format(IndexDefinition index)
Parameters
Type Name Description
IndexDefinition index
Returns
Type Description
System.String
View Source

FormatColumnRename(String, String, String)

Declaration
public override 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
View Source

FormatIdentity(ColumnDefinition)

Declaration
protected override string FormatIdentity(ColumnDefinition column)
Parameters
Type Name Description
ColumnDefinition column
Returns
Type Description
System.String
View Source

FormatSystemMethods(SystemMethods)

Declaration
protected override string FormatSystemMethods(SystemMethods systemMethod)
Parameters
Type Name Description
SystemMethods systemMethod
Returns
Type Description
System.String
View Source

FormatTableRename(String, String)

Declaration
public override string FormatTableRename(string oldName, string newName)
Parameters
Type Name Description
System.String oldName
System.String newName
Returns
Type Description
System.String
View Source

GetColumnsInSchema(IDatabase)

Declaration
public override IEnumerable<ColumnInfo> GetColumnsInSchema(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<ColumnInfo>
View Source

GetConstraintsPerColumn(IDatabase)

Declaration
public override IEnumerable<Tuple<string, string, string>> GetConstraintsPerColumn(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<Tuple<System.String, System.String, System.String>>
View Source

GetConstraintsPerTable(IDatabase)

Declaration
public override IEnumerable<Tuple<string, string>> GetConstraintsPerTable(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<Tuple<System.String, System.String>>
View Source

GetDefaultConstraintsPerColumn(IDatabase)

SQL Server stores default values assigned to columns as constraints, it also stores them with named values, this is the only server type that does this, therefore this method doesn't exist on any other syntax provider

Declaration
public IEnumerable<Tuple<string, string, string, string>> GetDefaultConstraintsPerColumn(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<Tuple<System.String, System.String, System.String, System.String>>
View Source

GetDefinedIndexes(IDatabase)

Declaration
public override IEnumerable<Tuple<string, string, string, bool>> GetDefinedIndexes(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<Tuple<System.String, System.String, System.String, System.Boolean>>
View Source

GetTablesInSchema(IDatabase)

Declaration
public override IEnumerable<string> GetTablesInSchema(IDatabase db)
Parameters
Type Name Description
IDatabase db
Returns
Type Description
IEnumerable<System.String>
View Source

GetUpdatedDatabaseType(DatabaseType, String)

Declaration
public override DatabaseType GetUpdatedDatabaseType(DatabaseType current, string connectionString)
Parameters
Type Name Description
DatabaseType current
System.String connectionString
Returns
Type Description
DatabaseType
View Source

InsertForUpdateHint(Sql<ISqlContext>)

Declaration
public override Sql<ISqlContext> InsertForUpdateHint(Sql<ISqlContext> sql)
Parameters
Type Name Description
Sql<ISqlContext> sql
Returns
Type Description
Sql<ISqlContext>
View Source

LeftJoinWithNestedJoin<TDto>(Sql<ISqlContext>, Func<Sql<ISqlContext>, Sql<ISqlContext>>, String)

Declaration
public override Sql<ISqlContext>.SqlJoinClause<ISqlContext> LeftJoinWithNestedJoin<TDto>(Sql<ISqlContext> sql, Func<Sql<ISqlContext>, Sql<ISqlContext>> nestedJoin, string alias = null)
Parameters
Type Name Description
Sql<ISqlContext> sql
Func<Sql<ISqlContext>, Sql<ISqlContext>> nestedJoin
System.String alias
Returns
Type Description
Sql.SqlJoinClause<ISqlContext>
Type Parameters
Name Description
TDto
View Source

SelectTop(Sql<ISqlContext>, Int32)

Declaration
public override Sql<ISqlContext> SelectTop(Sql<ISqlContext> sql, int top)
Parameters
Type Name Description
Sql<ISqlContext> sql
System.Int32 top
Returns
Type Description
Sql<ISqlContext>
View Source

TryGetDefaultConstraint(IDatabase, String, String, out String)

Declaration
public override 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