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

DeleteKeysAndIndexesBuilder(IMigrationContext, DatabaseType[])

Declaration

public DeleteKeysAndIndexesBuilder(IMigrationContext context, params DatabaseType[] supportedDatabaseTypes)

Parameters

Type	Name	Description
IMigrationContext	context
DatabaseType[]	supportedDatabaseTypes

Properties

DeleteForeign

Declaration

public bool DeleteForeign { get; set; }

Property Value

Type	Description
System.Boolean

DeleteLocal

Declaration

public bool DeleteLocal { get; set; }

Property Value

Type	Description
System.Boolean

TableName

Declaration

public string TableName { get; set; }

Property Value

Type	Description
System.String

Methods

Do()

Executes.

Declaration

public void Do()