Interface ISqlSyntaxProvider
Defines an SqlSyntaxProvider
Namespace:System.Dynamic.ExpandoObject
Assembly:Umbraco.Core.dll
Syntax
public interface ISqlSyntaxProvider
Properties
AddColumn
Declaration
string AddColumn { get; }
Property Value
Type |
Description |
System.String |
|
AlterColumn
Declaration
string AlterColumn { get; }
Property Value
Type |
Description |
System.String |
|
AlterSchema
Declaration
string AlterSchema { get; }
Property Value
Type |
Description |
System.String |
|
ConvertDateToOrderableString
Declaration
string ConvertDateToOrderableString { get; }
Property Value
Type |
Description |
System.String |
|
ConvertDecimalToOrderableString
Declaration
string ConvertDecimalToOrderableString { get; }
Property Value
Type |
Description |
System.String |
|
ConvertIntegerToOrderableString
Declaration
string ConvertIntegerToOrderableString { get; }
Property Value
Type |
Description |
System.String |
|
CreateConstraint
Declaration
string CreateConstraint { get; }
Property Value
Type |
Description |
System.String |
|
CreateForeignKeyConstraint
Declaration
string CreateForeignKeyConstraint { get; }
Property Value
Type |
Description |
System.String |
|
CreateIndex
Declaration
string CreateIndex { get; }
Property Value
Type |
Description |
System.String |
|
CreateSchema
Declaration
string CreateSchema { get; }
Property Value
Type |
Description |
System.String |
|
CreateTable
Declaration
string CreateTable { get; }
Property Value
Type |
Description |
System.String |
|
DeleteConstraint
Declaration
string DeleteConstraint { get; }
Property Value
Type |
Description |
System.String |
|
DeleteData
Declaration
string DeleteData { get; }
Property Value
Type |
Description |
System.String |
|
DeleteDefaultConstraint
Declaration
string DeleteDefaultConstraint { get; }
Property Value
Type |
Description |
System.String |
|
DropColumn
Declaration
string DropColumn { get; }
Property Value
Type |
Description |
System.String |
|
DropIndex
Declaration
string DropIndex { get; }
Property Value
Type |
Description |
System.String |
|
DropSchema
Declaration
string DropSchema { get; }
Property Value
Type |
Description |
System.String |
|
DropTable
Declaration
string DropTable { get; }
Property Value
Type |
Description |
System.String |
|
InsertData
Declaration
string InsertData { get; }
Property Value
Type |
Description |
System.String |
|
RenameColumn
Declaration
string RenameColumn { get; }
Property Value
Type |
Description |
System.String |
|
Declaration
string RenameTable { get; }
Property Value
Type |
Description |
System.String |
|
TruncateTable
Declaration
string TruncateTable { get; }
Property Value
Type |
Description |
System.String |
|
UpdateData
Declaration
string UpdateData { get; }
Property Value
Type |
Description |
System.String |
|
Methods
DoesTableExist(Database, String)
Declaration
bool DoesTableExist(Database db, string tableName)
Parameters
Type |
Name |
Description |
Database |
db |
|
System.String |
tableName |
|
Returns
Type |
Description |
System.Boolean |
|
EscapeString(String)
Declaration
string EscapeString(string val)
Parameters
Type |
Name |
Description |
System.String |
val |
|
Returns
Type |
Description |
System.String |
|
Declaration
string Format(IEnumerable<ColumnDefinition> columns)
Parameters
Type |
Name |
Description |
System.Collections.Generic.IEnumerable<ColumnDefinition> |
columns |
|
Returns
Type |
Description |
System.String |
|
Declaration
List<string> Format(IEnumerable<ForeignKeyDefinition> foreignKeys)
Parameters
Returns
Type |
Description |
System.Collections.Generic.List<System.String> |
|
Declaration
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> |
|
Declaration
string Format(ColumnDefinition column)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
string Format(ForeignKeyDefinition foreignKey)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
string Format(IndexDefinition index)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
string Format(TableDefinition table)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
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 |
|
Declaration
string FormatDateTime(DateTime date, bool includeTime = true)
Parameters
Type |
Name |
Description |
System.DateTime |
date |
|
System.Boolean |
includeTime |
|
Returns
Type |
Description |
System.String |
|
Declaration
string FormatPrimaryKey(TableDefinition table)
Parameters
Returns
Type |
Description |
System.String |
|
Declaration
string FormatTableRename(string oldName, string newName)
Parameters
Type |
Name |
Description |
System.String |
oldName |
|
System.String |
newName |
|
Returns
Type |
Description |
System.String |
|
GetColumnsInSchema(Database)
Declaration
IEnumerable<ColumnInfo> GetColumnsInSchema(Database db)
Parameters
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<ColumnInfo> |
|
GetConstraintsPerColumn(Database)
Declaration
IEnumerable<Tuple<string, string, string>> GetConstraintsPerColumn(Database db)
Parameters
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String, System.String>> |
|
GetConstraintsPerTable(Database)
Declaration
IEnumerable<Tuple<string, string>> GetConstraintsPerTable(Database db)
Parameters
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String>> |
|
GetDefinedIndexes(Database)
Declaration
IEnumerable<Tuple<string, string, string, bool>> GetDefinedIndexes(Database db)
Parameters
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String, System.String, System.Boolean>> |
|
GetIndexType(IndexTypes)
Declaration
string GetIndexType(IndexTypes indexTypes)
Parameters
Returns
Type |
Description |
System.String |
|
GetQuotedColumnName(String)
Declaration
string GetQuotedColumnName(string columnName)
Parameters
Type |
Name |
Description |
System.String |
columnName |
|
Returns
Type |
Description |
System.String |
|
GetQuotedName(String)
Declaration
string GetQuotedName(string name)
Parameters
Type |
Name |
Description |
System.String |
name |
|
Returns
Type |
Description |
System.String |
|
GetQuotedTableName(String)
Declaration
string GetQuotedTableName(string tableName)
Parameters
Type |
Name |
Description |
System.String |
tableName |
|
Returns
Type |
Description |
System.String |
|
GetQuotedValue(String)
Declaration
string GetQuotedValue(string value)
Parameters
Type |
Name |
Description |
System.String |
value |
|
Returns
Type |
Description |
System.String |
|
GetSpecialDbType(SpecialDbTypes)
Declaration
string GetSpecialDbType(SpecialDbTypes dbTypes)
Parameters
Returns
Type |
Description |
System.String |
|
GetStringColumnContainsComparison(String, String, TextColumnType)
Declaration
[Obsolete("Use the overload with the parameter index instead")]
string GetStringColumnContainsComparison(string column, string value, TextColumnType columnType)
Parameters
Type |
Name |
Description |
System.String |
column |
|
System.String |
value |
|
TextColumnType |
columnType |
|
Returns
Type |
Description |
System.String |
|
GetStringColumnEndsWithComparison(String, String, TextColumnType)
Declaration
[Obsolete("Use the overload with the parameter index instead")]
string GetStringColumnEndsWithComparison(string column, string value, TextColumnType columnType)
Parameters
Type |
Name |
Description |
System.String |
column |
|
System.String |
value |
|
TextColumnType |
columnType |
|
Returns
Type |
Description |
System.String |
|
GetStringColumnEqualComparison(String, Int32, TextColumnType)
Declaration
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 |
|
GetStringColumnEqualComparison(String, String, TextColumnType)
Declaration
[Obsolete("Use the overload with the parameter index instead")]
string GetStringColumnEqualComparison(string column, string value, TextColumnType columnType)
Parameters
Type |
Name |
Description |
System.String |
column |
|
System.String |
value |
|
TextColumnType |
columnType |
|
Returns
Type |
Description |
System.String |
|
GetStringColumnStartsWithComparison(String, String, TextColumnType)
Declaration
[Obsolete("Use the overload with the parameter index instead")]
string GetStringColumnStartsWithComparison(string column, string value, TextColumnType columnType)
Parameters
Type |
Name |
Description |
System.String |
column |
|
System.String |
value |
|
TextColumnType |
columnType |
|
Returns
Type |
Description |
System.String |
|
GetStringColumnWildcardComparison(String, Int32, TextColumnType)
Declaration
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 |
|
GetStringColumnWildcardComparison(String, String, TextColumnType)
Declaration
[Obsolete("Use the overload with the parameter index instead")]
string GetStringColumnWildcardComparison(string column, string value, TextColumnType columnType)
Parameters
Type |
Name |
Description |
System.String |
column |
|
System.String |
value |
|
TextColumnType |
columnType |
|
Returns
Type |
Description |
System.String |
|
GetTablesInSchema(Database)
Declaration
IEnumerable<string> GetTablesInSchema(Database db)
Parameters
Returns
Type |
Description |
System.Collections.Generic.IEnumerable<System.String> |
|
GetWildcardPlaceholder()
Declaration
string GetWildcardPlaceholder()
Returns
Type |
Description |
System.String |
|
SelectTop(Sql, Int32)
Declaration
Sql SelectTop(Sql sql, int top)
Parameters
Type |
Name |
Description |
Sql |
sql |
|
System.Int32 |
top |
|
Returns
SupportsCaseInsensitiveQueries(Database)
Declaration
bool ? SupportsCaseInsensitiveQueries(Database db)
Parameters
Returns
Type |
Description |
System.Nullable<System.Boolean> |
|
SupportsClustered()
Declaration
Returns
Type |
Description |
System.Boolean |
|
SupportsIdentityInsert()
Declaration
bool SupportsIdentityInsert()
Returns
Type |
Description |
System.Boolean |
|