View Source

Class AlterTableBuilder

Inheritance
System.Object
ExpressionBuilderBase<AlterTableExpression>
ExpressionBuilderBase<AlterTableExpression, IAlterTableColumnOptionBuilder>
Namespace: Umbraco.Cms.Infrastructure.Migrations.Expressions.Alter.Table
Assembly: Umbraco.Infrastructure.dll
Syntax
public class AlterTableBuilder : ExpressionBuilderBase<AlterTableExpression, IAlterTableColumnOptionBuilder>, IAlterTableColumnTypeBuilder, IColumnTypeBuilder<IAlterTableColumnOptionBuilder>, IAlterTableColumnOptionForeignKeyCascadeBuilder, IAlterTableColumnOptionBuilder, IColumnOptionBuilder<IAlterTableColumnOptionBuilder, IAlterTableColumnOptionForeignKeyCascadeBuilder>, IAlterTableBuilder, IExecutableBuilder, IForeignKeyCascadeBuilder<IAlterTableColumnOptionBuilder, IAlterTableColumnOptionForeignKeyCascadeBuilder>, IFluentBuilder

Constructors

View Source

AlterTableBuilder(IMigrationContext, AlterTableExpression)

Declaration
public AlterTableBuilder(IMigrationContext context, AlterTableExpression expression)
Parameters
Type Name Description
IMigrationContext context
AlterTableExpression expression

Properties

View Source

CurrentColumn

Declaration
public ColumnDefinition CurrentColumn { get; set; }
Property Value
Type Description
ColumnDefinition
View Source

CurrentForeignKey

Declaration
public ForeignKeyDefinition CurrentForeignKey { get; set; }
Property Value
Type Description
ForeignKeyDefinition

Methods

View Source

AddColumn(String)

Declaration
public IAlterTableColumnTypeBuilder AddColumn(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
IAlterTableColumnTypeBuilder
View Source

AlterColumn(String)

Declaration
public IAlterTableColumnTypeBuilder AlterColumn(string name)
Parameters
Type Name Description
System.String name
Returns
Type Description
IAlterTableColumnTypeBuilder
View Source

Do()

Declaration
public void Do()
View Source

ForeignKey()

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey()
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

ForeignKey(String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey(string primaryTableName, string primaryColumnName)
Parameters
Type Name Description
System.String primaryTableName
System.String primaryColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

ForeignKey(String, String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey(string foreignKeyName, string primaryTableName, string primaryColumnName)
Parameters
Type Name Description
System.String foreignKeyName
System.String primaryTableName
System.String primaryColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

ForeignKey(String, String, String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey(string foreignKeyName, string primaryTableSchema, string primaryTableName, string primaryColumnName)
Parameters
Type Name Description
System.String foreignKeyName
System.String primaryTableSchema
System.String primaryTableName
System.String primaryColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

GetColumnForType()

Declaration
public override ColumnDefinition GetColumnForType()
Returns
Type Description
ColumnDefinition
View Source

Identity()

Declaration
public IAlterTableColumnOptionBuilder Identity()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

Indexed()

Declaration
public IAlterTableColumnOptionBuilder Indexed()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

Indexed(String)

Declaration
public IAlterTableColumnOptionBuilder Indexed(string indexName)
Parameters
Type Name Description
System.String indexName
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

NotNullable()

Declaration
public IAlterTableColumnOptionBuilder NotNullable()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

Nullable()

Declaration
public IAlterTableColumnOptionBuilder Nullable()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

OnDelete(Rule)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder OnDelete(Rule rule)
Parameters
Type Name Description
System.Data.Rule rule
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

OnDeleteOrUpdate(Rule)

Declaration
public IAlterTableColumnOptionBuilder OnDeleteOrUpdate(Rule rule)
Parameters
Type Name Description
System.Data.Rule rule
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

OnUpdate(Rule)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder OnUpdate(Rule rule)
Parameters
Type Name Description
System.Data.Rule rule
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

PrimaryKey()

Declaration
public IAlterTableColumnOptionBuilder PrimaryKey()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

PrimaryKey(String)

Declaration
public IAlterTableColumnOptionBuilder PrimaryKey(string primaryKeyName)
Parameters
Type Name Description
System.String primaryKeyName
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

ReferencedBy(String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ReferencedBy(string foreignTableName, string foreignColumnName)
Parameters
Type Name Description
System.String foreignTableName
System.String foreignColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

ReferencedBy(String, String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ReferencedBy(string foreignKeyName, string foreignTableName, string foreignColumnName)
Parameters
Type Name Description
System.String foreignKeyName
System.String foreignTableName
System.String foreignColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

ReferencedBy(String, String, String, String)

Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ReferencedBy(string foreignKeyName, string foreignTableSchema, string foreignTableName, string foreignColumnName)
Parameters
Type Name Description
System.String foreignKeyName
System.String foreignTableSchema
System.String foreignTableName
System.String foreignColumnName
Returns
Type Description
IAlterTableColumnOptionForeignKeyCascadeBuilder
View Source

Unique()

Declaration
public IAlterTableColumnOptionBuilder Unique()
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

Unique(String)

Declaration
public IAlterTableColumnOptionBuilder Unique(string indexName)
Parameters
Type Name Description
System.String indexName
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

WithDefault(SystemMethods)

Declaration
public IAlterTableColumnOptionBuilder WithDefault(SystemMethods method)
Parameters
Type Name Description
SystemMethods method
Returns
Type Description
IAlterTableColumnOptionBuilder
View Source

WithDefaultValue(Object)

Declaration
public IAlterTableColumnOptionBuilder WithDefaultValue(object value)
Parameters
Type Name Description
System.Object value
Returns
Type Description
IAlterTableColumnOptionBuilder