View Source

Class CreateTableBuilder

Inheritance
System.Object
ExpressionBuilderBase<CreateTableExpression>
ExpressionBuilderBase<CreateTableExpression, ICreateTableColumnOptionBuilder>
Namespace: Umbraco.Cms.Infrastructure.Migrations.Expressions.Create.Table
Assembly: Umbraco.Infrastructure.dll
Syntax
public class CreateTableBuilder : ExpressionBuilderBase<CreateTableExpression, ICreateTableColumnOptionBuilder>, ICreateTableColumnAsTypeBuilder, IColumnTypeBuilder<ICreateTableColumnOptionBuilder>, ICreateTableColumnOptionForeignKeyCascadeBuilder, ICreateTableColumnOptionBuilder, IColumnOptionBuilder<ICreateTableColumnOptionBuilder, ICreateTableColumnOptionForeignKeyCascadeBuilder>, ICreateTableWithColumnBuilder, IExecutableBuilder, IForeignKeyCascadeBuilder<ICreateTableColumnOptionBuilder, ICreateTableColumnOptionForeignKeyCascadeBuilder>, IFluentBuilder

Constructors

View Source

CreateTableBuilder(IMigrationContext, CreateTableExpression)

Declaration
public CreateTableBuilder(IMigrationContext context, CreateTableExpression expression)
Parameters
Type Name Description
IMigrationContext context
CreateTableExpression 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

Do()

Executes.

Declaration
public void Do()
View Source

ForeignKey()

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

ForeignKey(String, String)

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

ForeignKey(String, String, String)

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

ForeignKey(String, String, String, String)

Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder 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
ICreateTableColumnOptionForeignKeyCascadeBuilder
View Source

GetColumnForType()

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

Identity()

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

Indexed()

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

Indexed(String)

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

NotNullable()

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

Nullable()

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

OnDelete(Rule)

Specifies a rule on deletes.

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

OnDeleteOrUpdate(Rule)

Specifies a rule on deletes and updates.

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

OnUpdate(Rule)

Specifies a rule on updates.

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

PrimaryKey()

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

PrimaryKey(String)

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

ReferencedBy(String, String)

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

ReferencedBy(String, String, String)

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

ReferencedBy(String, String, String, String)

Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder 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
ICreateTableColumnOptionForeignKeyCascadeBuilder
View Source

Unique()

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

Unique(String)

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

WithColumn(String)

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

WithDefault(SystemMethods)

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

WithDefaultValue(Object)

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