View Source

Class SqliteSyntaxProvider

Implements ISqlSyntaxProvider for SQLite.

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

Constructors

View Source

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

Declaration
public SqliteSyntaxProvider(IOptions<GlobalSettings> globalSettings, ILogger<SqliteSyntaxProvider> log)
Parameters
Type Name Description
IOptions<GlobalSettings> globalSettings
ILogger<SqliteSyntaxProvider> log

Properties

View Source

ConvertDateToOrderableString

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

ConvertDecimalToOrderableString

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

ConvertIntegerToOrderableString

Declaration
public override string ConvertIntegerToOrderableString { 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

ProviderName

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

ScalarMappers

Declaration
public override IDictionary<Type, IScalarMapper> ScalarMappers { get; }
Property Value
Type Description
IDictionary<Type, IScalarMapper>
View Source

StringColumnDefinition

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

StringLengthUnicodeColumnDefinitionFormat

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

Methods

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

Format(IEnumerable<ColumnDefinition>)

Declaration
public virtual string Format(IEnumerable<ColumnDefinition> columns)
Parameters
Type Name Description
IEnumerable<ColumnDefinition> columns
Returns
Type Description
System.String
View Source

Format(IEnumerable<ForeignKeyDefinition>)

Declaration
public override List<string> Format(IEnumerable<ForeignKeyDefinition> foreignKeys)
Parameters
Type Name Description
IEnumerable<ForeignKeyDefinition> foreignKeys
Returns
Type Description
List<System.String>
View Source

Format(ForeignKeyDefinition)

Declaration
public virtual string Format(ForeignKeyDefinition foreignKey)
Parameters
Type Name Description
ForeignKeyDefinition foreignKey
Returns
Type Description
System.String
View Source

Format(TableDefinition)

Declaration
public override string Format(TableDefinition table)
Parameters
Type Name Description
TableDefinition table
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

FormatPrimaryKey(TableDefinition)

Declaration
public override string FormatPrimaryKey(TableDefinition table)
Parameters
Type Name Description
TableDefinition table
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

GetColumn(DatabaseType, String, String, String, String, Boolean)

Declaration
public override string GetColumn(DatabaseType dbType, string tableName, string columnName, string columnAlias, string referenceName = null, bool forInsert = false)
Parameters
Type Name Description
DatabaseType dbType
System.String tableName
System.String columnName
System.String columnAlias
System.String referenceName
System.Boolean forInsert
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

GetConcat(String[])

Declaration
public override string GetConcat(params string[] args)
Parameters
Type Name Description
System.String[] args
Returns
Type Description
System.String
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

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

GetFieldNameForUpdate<TDto>(Expression<Func<TDto, Object>>, String)

Declaration
public override string GetFieldNameForUpdate<TDto>(Expression<Func<TDto, object>> fieldSelector, string tableAlias = null)
Parameters
Type Name Description
System.Linq.Expressions.Expression<Func<TDto, System.Object>> fieldSelector
System.String tableAlias
Returns
Type Description
System.String
Type Parameters
Name Description
TDto
View Source

GetIndexType(IndexTypes)

Declaration
public override string GetIndexType(IndexTypes indexTypes)
Parameters
Type Name Description
IndexTypes indexTypes
Returns
Type Description
System.String
View Source

GetSpecialDbType(SpecialDbType)

Declaration
public override string GetSpecialDbType(SpecialDbType dbType)
Parameters
Type Name Description
SpecialDbType dbType
Returns
Type Description
System.String
View Source

GetSpecialDbType(SpecialDbType, Int32)

Declaration
public override string GetSpecialDbType(SpecialDbType dbType, int customSize)
Parameters
Type Name Description
SpecialDbType dbType
System.Int32 customSize
Returns
Type Description
System.String
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

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

SupportsClustered()

Declaration
public override bool SupportsClustered()
Returns
Type Description
System.Boolean
View Source

SupportsIdentityInsert()

Declaration
public override bool SupportsIdentityInsert()
Returns
Type Description
System.Boolean
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