View Source
Class AlterTableBuilder
Inheritance
System.Object
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
Properties
View Source
CurrentColumn
Declaration
public ColumnDefinition CurrentColumn { get; set; }
Property Value
View Source
CurrentForeignKey
Declaration
public ForeignKeyDefinition CurrentForeignKey { get; set; }
Property Value
Methods
View Source
AddColumn(String)
Declaration
public IAlterTableColumnTypeBuilder AddColumn(string name)
Parameters
Type |
Name |
Description |
System.String |
name |
|
Returns
View Source
AlterColumn(String)
Declaration
public IAlterTableColumnTypeBuilder AlterColumn(string name)
Parameters
Type |
Name |
Description |
System.String |
name |
|
Returns
View Source
Do()
Declaration
View Source
ForeignKey()
Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey()
Returns
View Source
ForeignKey(String, String)
Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ForeignKey(string primaryTableName, string primaryColumnName)
Parameters
Type |
Name |
Description |
System.String |
primaryTableName |
|
System.String |
primaryColumnName |
|
Returns
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
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
View Source
GetColumnForType()
Declaration
public override ColumnDefinition GetColumnForType()
Returns
View Source
Identity()
Declaration
public IAlterTableColumnOptionBuilder Identity()
Returns
View Source
Indexed()
Declaration
public IAlterTableColumnOptionBuilder Indexed()
Returns
View Source
Indexed(String)
Declaration
public IAlterTableColumnOptionBuilder Indexed(string indexName)
Parameters
Type |
Name |
Description |
System.String |
indexName |
|
Returns
View Source
NotNullable()
Declaration
public IAlterTableColumnOptionBuilder NotNullable()
Returns
View Source
Nullable()
Declaration
public IAlterTableColumnOptionBuilder Nullable()
Returns
View Source
OnDelete(Rule)
Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder OnDelete(Rule rule)
Parameters
Type |
Name |
Description |
System.Data.Rule |
rule |
|
Returns
View Source
OnDeleteOrUpdate(Rule)
Declaration
public IAlterTableColumnOptionBuilder OnDeleteOrUpdate(Rule rule)
Parameters
Type |
Name |
Description |
System.Data.Rule |
rule |
|
Returns
View Source
OnUpdate(Rule)
Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder OnUpdate(Rule rule)
Parameters
Type |
Name |
Description |
System.Data.Rule |
rule |
|
Returns
View Source
PrimaryKey()
Declaration
public IAlterTableColumnOptionBuilder PrimaryKey()
Returns
View Source
PrimaryKey(String)
Declaration
public IAlterTableColumnOptionBuilder PrimaryKey(string primaryKeyName)
Parameters
Type |
Name |
Description |
System.String |
primaryKeyName |
|
Returns
View Source
ReferencedBy(String, String)
Declaration
public IAlterTableColumnOptionForeignKeyCascadeBuilder ReferencedBy(string foreignTableName, string foreignColumnName)
Parameters
Type |
Name |
Description |
System.String |
foreignTableName |
|
System.String |
foreignColumnName |
|
Returns
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
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
View Source
Unique()
Declaration
public IAlterTableColumnOptionBuilder Unique()
Returns
View Source
Unique(String)
Declaration
public IAlterTableColumnOptionBuilder Unique(string indexName)
Parameters
Type |
Name |
Description |
System.String |
indexName |
|
Returns
View Source
WithDefault(SystemMethods)
Declaration
public IAlterTableColumnOptionBuilder WithDefault(SystemMethods method)
Parameters
Returns
View Source
WithDefaultValue(Object)
Declaration
public IAlterTableColumnOptionBuilder WithDefaultValue(object value)
Parameters
Type |
Name |
Description |
System.Object |
value |
|
Returns