Class CreateTableBuilder

Inheritance

System.Object

ExpressionBuilderBase<CreateTableExpression>

ExpressionBuilderBase<CreateTableExpression, ICreateTableColumnOptionBuilder>

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

Assembly: cs.temp.dll.dll

Syntax

public class CreateTableBuilder : ExpressionBuilderBase<CreateTableExpression, ICreateTableColumnOptionBuilder>, ICreateTableColumnAsTypeBuilder, ICreateTableColumnOptionForeignKeyCascadeBuilder, ICreateTableColumnOptionBuilder, ICreateTableWithColumnBuilder, IFluentBuilder

Constructors

CreateTableBuilder(IMigrationContext, CreateTableExpression)

Declaration

public CreateTableBuilder(IMigrationContext context, CreateTableExpression expression)

Parameters

Type	Name	Description
IMigrationContext	context
CreateTableExpression	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

Do()

Declaration

public void Do()

ForeignKey()

Declaration

public ICreateTableColumnOptionForeignKeyCascadeBuilder ForeignKey()

Returns

Type	Description
ICreateTableColumnOptionForeignKeyCascadeBuilder

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

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

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

GetColumnForType()

Declaration

public override ColumnDefinition GetColumnForType()

Returns

Type	Description
ColumnDefinition

Identity()

Declaration

public ICreateTableColumnOptionBuilder Identity()

Returns

Type	Description
ICreateTableColumnOptionBuilder

Indexed()

Declaration

public ICreateTableColumnOptionBuilder Indexed()

Returns

Type	Description
ICreateTableColumnOptionBuilder

Indexed(String)

Declaration

public ICreateTableColumnOptionBuilder Indexed(string indexName)

Parameters

Type	Name	Description
System.String	indexName

Returns

Type	Description
ICreateTableColumnOptionBuilder

NotNullable()

Declaration

public ICreateTableColumnOptionBuilder NotNullable()

Returns

Type	Description
ICreateTableColumnOptionBuilder

Nullable()

Declaration

public ICreateTableColumnOptionBuilder Nullable()

Returns

Type	Description
ICreateTableColumnOptionBuilder

OnDelete(Rule)

Declaration

public ICreateTableColumnOptionForeignKeyCascadeBuilder OnDelete(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
ICreateTableColumnOptionForeignKeyCascadeBuilder

OnDeleteOrUpdate(Rule)

Declaration

public ICreateTableColumnOptionBuilder OnDeleteOrUpdate(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
ICreateTableColumnOptionBuilder

OnUpdate(Rule)

Declaration

public ICreateTableColumnOptionForeignKeyCascadeBuilder OnUpdate(Rule rule)

Parameters

Type	Name	Description
Rule	rule

Returns

Type	Description
ICreateTableColumnOptionForeignKeyCascadeBuilder

PrimaryKey()

Declaration

public ICreateTableColumnOptionBuilder PrimaryKey()

Returns

Type	Description
ICreateTableColumnOptionBuilder

PrimaryKey(String)

Declaration

public ICreateTableColumnOptionBuilder PrimaryKey(string primaryKeyName)

Parameters

Type	Name	Description
System.String	primaryKeyName

Returns

Type	Description
ICreateTableColumnOptionBuilder

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

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

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

Unique()

Declaration

public ICreateTableColumnOptionBuilder Unique()

Returns

Type	Description
ICreateTableColumnOptionBuilder

Unique(String)

Declaration

public ICreateTableColumnOptionBuilder Unique(string indexName)

Parameters

Type	Name	Description
System.String	indexName

Returns

Type	Description
ICreateTableColumnOptionBuilder

WithColumn(String)

Declaration

public ICreateTableColumnAsTypeBuilder WithColumn(string name)

Parameters

Type	Name	Description
System.String	name

Returns

Type	Description
ICreateTableColumnAsTypeBuilder

WithDefault(SystemMethods)

Declaration

public ICreateTableColumnOptionBuilder WithDefault(SystemMethods method)

Parameters

Type	Name	Description
SystemMethods	method

Returns

Type	Description
ICreateTableColumnOptionBuilder

WithDefaultValue(Object)

Declaration

public ICreateTableColumnOptionBuilder WithDefaultValue(object value)

Parameters

Type	Name	Description
System.Object	value

Returns

Type	Description
ICreateTableColumnOptionBuilder