Class CreateTableBuilder
Inheritance
System.Object
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
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
ForeignKey()
Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder ForeignKey()
Returns
ForeignKey(String, String)
Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder ForeignKey(string primaryTableName, string primaryColumnName)
Parameters
Type |
Name |
Description |
System.String |
primaryTableName |
|
System.String |
primaryColumnName |
|
Returns
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
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
GetColumnForType()
Declaration
public override ColumnDefinition GetColumnForType()
Returns
Type |
Description |
ColumnDefinition |
|
Identity()
Declaration
public ICreateTableColumnOptionBuilder Identity()
Returns
Indexed()
Declaration
public ICreateTableColumnOptionBuilder Indexed()
Returns
Indexed(String)
Declaration
public ICreateTableColumnOptionBuilder Indexed(string indexName)
Parameters
Type |
Name |
Description |
System.String |
indexName |
|
Returns
NotNullable()
Declaration
public ICreateTableColumnOptionBuilder NotNullable()
Returns
Nullable()
Declaration
public ICreateTableColumnOptionBuilder Nullable()
Returns
OnDelete(Rule)
Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder OnDelete(Rule rule)
Parameters
Type |
Name |
Description |
Rule |
rule |
|
Returns
OnDeleteOrUpdate(Rule)
Declaration
public ICreateTableColumnOptionBuilder OnDeleteOrUpdate(Rule rule)
Parameters
Type |
Name |
Description |
Rule |
rule |
|
Returns
OnUpdate(Rule)
Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder OnUpdate(Rule rule)
Parameters
Type |
Name |
Description |
Rule |
rule |
|
Returns
PrimaryKey()
Declaration
public ICreateTableColumnOptionBuilder PrimaryKey()
Returns
PrimaryKey(String)
Declaration
public ICreateTableColumnOptionBuilder PrimaryKey(string primaryKeyName)
Parameters
Type |
Name |
Description |
System.String |
primaryKeyName |
|
Returns
ReferencedBy(String, String)
Declaration
public ICreateTableColumnOptionForeignKeyCascadeBuilder ReferencedBy(string foreignTableName, string foreignColumnName)
Parameters
Type |
Name |
Description |
System.String |
foreignTableName |
|
System.String |
foreignColumnName |
|
Returns
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
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
Unique()
Declaration
public ICreateTableColumnOptionBuilder Unique()
Returns
Unique(String)
Declaration
public ICreateTableColumnOptionBuilder Unique(string indexName)
Parameters
Type |
Name |
Description |
System.String |
indexName |
|
Returns
WithColumn(String)
Declaration
public ICreateTableColumnAsTypeBuilder WithColumn(string name)
Parameters
Type |
Name |
Description |
System.String |
name |
|
Returns
WithDefault(SystemMethods)
Declaration
public ICreateTableColumnOptionBuilder WithDefault(SystemMethods method)
Parameters
Type |
Name |
Description |
SystemMethods |
method |
|
Returns
WithDefaultValue(Object)
Declaration
public ICreateTableColumnOptionBuilder WithDefaultValue(object value)
Parameters
Type |
Name |
Description |
System.Object |
value |
|
Returns