Class AlterTableBuilder

Inheritance

System.Object

ExpressionBuilderBase<AlterTableExpression>

ExpressionBuilderBase<AlterTableExpression, IAlterTableColumnOptionBuilder>

Namespace: Umbraco.Cms.Infrastructure.Migrations.Expressions.Alter.Table

Assembly: cs.temp.dll.dll

Syntax

public class AlterTableBuilder : ExpressionBuilderBase<AlterTableExpression, IAlterTableColumnOptionBuilder>, IAlterTableColumnTypeBuilder, IAlterTableColumnOptionForeignKeyCascadeBuilder, IAlterTableColumnOptionBuilder, IAlterTableBuilder, IFluentBuilder

Constructors

AlterTableBuilder(IMigrationContext, AlterTableExpression)

Declaration

public AlterTableBuilder(IMigrationContext context, AlterTableExpression expression)

Parameters

Type	Name	Description
IMigrationContext	context
AlterTableExpression	expression

Properties

CurrentColumn

Declaration

public ColumnDefinition CurrentColumn { get; set; }

Property Value

Type	Description
ColumnDefinition

CurrentForeignKey

Declaration

public ForeignKeyDefinition CurrentForeignKey { get; set; }

Property Value

Type	Description
ForeignKeyDefinition

Methods

AddColumn(String)

Declaration

public IAlterTableColumnTypeBuilder AddColumn(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
IAlterTableColumnTypeBuilder

AlterColumn(String)

Declaration

public IAlterTableColumnTypeBuilder AlterColumn(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
IAlterTableColumnTypeBuilder

Do()

Declaration

public void Do()

ForeignKey()

Declaration

public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey()

Returns

Type	Description
IAlterTableColumnOptionForeignKeyCascadeBuilder

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

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

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

GetColumnForType()

Declaration

public override ColumnDefinition GetColumnForType()

Returns

Type	Description
ColumnDefinition

Identity()

Declaration

public IAlterTableColumnOptionBuilder Identity()

Returns

Type	Description
IAlterTableColumnOptionBuilder

Indexed()

Declaration

public IAlterTableColumnOptionBuilder Indexed()

Returns

Type	Description
IAlterTableColumnOptionBuilder

Indexed(String)

Declaration

public IAlterTableColumnOptionBuilder Indexed(string indexName)

Parameters

Type	Name	Description
System.String	indexName

Returns

Type	Description
IAlterTableColumnOptionBuilder

NotNullable()

Declaration

public IAlterTableColumnOptionBuilder NotNullable()

Returns

Type	Description
IAlterTableColumnOptionBuilder

Nullable()

Declaration

public IAlterTableColumnOptionBuilder Nullable()

Returns

Type	Description
IAlterTableColumnOptionBuilder

OnDelete(Rule)

Declaration

public IAlterTableColumnOptionForeignKeyCascadeBuilder OnDelete(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
IAlterTableColumnOptionForeignKeyCascadeBuilder

OnDeleteOrUpdate(Rule)

Declaration

public IAlterTableColumnOptionBuilder OnDeleteOrUpdate(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
IAlterTableColumnOptionBuilder

OnUpdate(Rule)

Declaration

public IAlterTableColumnOptionForeignKeyCascadeBuilder OnUpdate(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
IAlterTableColumnOptionForeignKeyCascadeBuilder

PrimaryKey()

Declaration

public IAlterTableColumnOptionBuilder PrimaryKey()

Returns

Type	Description
IAlterTableColumnOptionBuilder

PrimaryKey(String)

Declaration

public IAlterTableColumnOptionBuilder PrimaryKey(string primaryKeyName)

Parameters

Type	Name	Description
System.String	primaryKeyName

Returns

Type	Description
IAlterTableColumnOptionBuilder

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

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

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

Unique()

Declaration

public IAlterTableColumnOptionBuilder Unique()

Returns

Type	Description
IAlterTableColumnOptionBuilder

Unique(String)

Declaration

public IAlterTableColumnOptionBuilder Unique(string indexName)

Parameters

Type	Name	Description
System.String	indexName

Returns

Type	Description
IAlterTableColumnOptionBuilder

WithDefault(SystemMethods)

Declaration

public IAlterTableColumnOptionBuilder WithDefault(SystemMethods method)

Parameters

Type	Name	Description
SystemMethods	method

Returns

Type	Description
IAlterTableColumnOptionBuilder

WithDefaultValue(Object)

Declaration

public IAlterTableColumnOptionBuilder WithDefaultValue(object value)

Parameters

Type	Name	Description
System.Object	value

Returns

Type	Description
IAlterTableColumnOptionBuilder