View Source

Class SqlCeSyntaxProvider

Represents an SqlSyntaxProvider for Sql Ce

Inheritance

System.Object

SqlSyntaxProviderBase<SqlCeSyntaxProvider>

MicrosoftSqlSyntaxProviderBase<SqlCeSyntaxProvider>

Namespace: Umbraco.Core.Persistence.SqlSyntax

Assembly: Umbraco.Core.dll

Syntax

public class SqlCeSyntaxProvider : MicrosoftSqlSyntaxProviderBase<SqlCeSyntaxProvider>, ISqlSyntaxProvider2, ISqlSyntaxProvider

Constructors

View Source

SqlCeSyntaxProvider()

Declaration

public SqlCeSyntaxProvider()

Properties

View Source

CreateIndex

Declaration

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

TruncateTable

SqlCe doesn't support the Truncate Table syntax, so we just have to do a DELETE FROM which is slower but we have no choice.

Declaration

public override string TruncateTable { get; }

Property Value

Type	Description
System.String

Methods

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

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

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
System.Collections.Generic.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
System.Collections.Generic.IEnumerable<System.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
System.Collections.Generic.IEnumerable<System.Tuple<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
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.String, System.String, System.Boolean>>

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(SpecialDbTypes)

Declaration

public override string GetSpecialDbType(SpecialDbTypes dbTypes)

Parameters

Type	Name	Description
SpecialDbTypes	dbTypes

Returns

Type	Description
System.String

View Source

GetSqlDbType(DbType)

Declaration

public override SqlDbType GetSqlDbType(DbType dbType)

Parameters

Type	Name	Description
System.Data.DbType	dbType

Returns

Type	Description
System.Data.SqlDbType

View Source

GetTablesInSchema(IDatabase)

Declaration

public override IEnumerable<string> GetTablesInSchema(IDatabase db)

Parameters

Type	Name	Description
IDatabase	db

Returns

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

View Source

ReadLock(IDatabase, Int32[])

Declaration

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

Parameters

Type	Name	Description
IDatabase	db
System.Int32[]	lockIds

View Source

ReadLock(IDatabase, TimeSpan, Int32)

Declaration

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

Parameters

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

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

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

View Source

WriteLock(IDatabase, Int32[])

Declaration

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

Parameters

Type	Name	Description
IDatabase	db
System.Int32[]	lockIds

View Source

WriteLock(IDatabase, TimeSpan, Int32)

Declaration

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

Parameters

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