View Source
Class MicrosoftSqlSyntaxProviderBase<TSyntax>
Abstract class for defining MS sql implementations
Inheritance
System.Object
Assembly: Umbraco.Core.dll
Syntax
public abstract class MicrosoftSqlSyntaxProviderBase<TSyntax> : SqlSyntaxProviderBase<TSyntax>, ISqlSyntaxProvider2, ISqlSyntaxProvider where TSyntax : ISqlSyntaxProvider
Type Parameters
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
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 |
System.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 |
|