View Source

Class DeleteKeysAndIndexesBuilder

Inheritance
System.Object
Namespace: Umbraco.Cms.Infrastructure.Migrations.Expressions.Delete.KeysAndIndexes
Assembly: Umbraco.Infrastructure.dll
Syntax
public class DeleteKeysAndIndexesBuilder : IExecutableBuilder
Remarks

Assuming we stick with the current migrations setup this will need to be altered to delegate to SQL syntax provider (we can drop indexes but not PK/FK).

1. For SQLite, rename table.
2. Create new table with expected keys.
3. Insert into new from renamed
4. Drop renamed.

Read more SQL Features That SQLite Does Not Implement

Constructors

View Source

DeleteKeysAndIndexesBuilder(IMigrationContext, DatabaseType[])

Declaration
public DeleteKeysAndIndexesBuilder(IMigrationContext context, params DatabaseType[] supportedDatabaseTypes)
Parameters
Type Name Description
IMigrationContext context
DatabaseType[] supportedDatabaseTypes

Properties

View Source

DeleteForeign

Declaration
public bool DeleteForeign { get; set; }
Property Value
Type Description
System.Boolean
View Source

DeleteLocal

Declaration
public bool DeleteLocal { get; set; }
Property Value
Type Description
System.Boolean
View Source

TableName

Declaration
public string TableName { get; set; }
Property Value
Type Description
System.String

Methods

View Source

Do()

Executes.

Declaration
public void Do()