Class SqlServer2005Generator

Inheritance

object

GeneratorBase

GenericGenerator

SqlServer2000Generator

SqlServer2005Generator

SqlServer2008Generator

SqlServer2008Generator

SqlServer2008Generator

SqlServer2008Generator

Implements

IMigrationGenerator

Inherited Members

SqlServer2000Generator.DropTableIfExists

SqlServer2000Generator.RenameTable

SqlServer2000Generator.RenameColumn

SqlServer2000Generator.CreateConstraint

SqlServer2000Generator.GetClusterTypeString(CreateIndexExpression)

SqlServer2000Generator.GetConstraintClusteringString(CreateConstraintExpression)

SqlServer2000Generator.Generate(RenameTableExpression)

SqlServer2000Generator.Generate(RenameColumnExpression)

SqlServer2000Generator.Generate(DeleteColumnExpression)

SqlServer2000Generator.BuildDelete(DeleteColumnExpression, string, StringBuilder)

SqlServer2000Generator.Generate(AlterDefaultConstraintExpression)

SqlServer2000Generator.Generate(InsertDataExpression)

SqlServer2000Generator.IsUsingIdentityInsert(InsertDataExpression)

SqlServer2000Generator.Generate(CreateSequenceExpression)

SqlServer2000Generator.Generate(DeleteSequenceExpression)

GenericGenerator.compatabilityMode

GenericGenerator.CompatibilityMode

GenericGenerator.CreateTable

GenericGenerator.DropTable

GenericGenerator.DropColumn

GenericGenerator.AlterColumn

GenericGenerator.AlterSchema

GenericGenerator.DropSchema

GenericGenerator.InsertData

GenericGenerator.UpdateData

GenericGenerator.DeleteData

GenericGenerator.DeleteConstraint

GenericGenerator.GetUniqueString(CreateIndexExpression)

GenericGenerator.GenerateForeignKeyName(ForeignKeyDefinition)

GenericGenerator.Generate(DeleteForeignKeyExpression)

GenericGenerator.AppendSqlStatementEndToken(StringBuilder)

GenericGenerator.GenerateColumnNamesAndValues(InsertDataExpression)

GenericGenerator.ValidateAdditionalFeatureCompatibility(IEnumerable<KeyValuePair<string, object>>)

GenericGenerator.Generate(UpdateDataExpression)

GenericGenerator.Generate(DeleteDataExpression)

GeneratorBase.Column

GeneratorBase.Quoter

GeneratorBase.DescriptionGenerator

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: FluentMigrator.Runner.Generators.SqlServer

Assembly: FluentMigrator.Runner.SqlServer.dll

Syntax

public class SqlServer2005Generator : SqlServer2000Generator, IMigrationGenerator

Constructors

SqlServer2005Generator()

Declaration

public SqlServer2005Generator()

SqlServer2005Generator(IColumn, IQuoter, IDescriptionGenerator, IOptions<GeneratorOptions>)

Declaration

protected SqlServer2005Generator(IColumn column, IQuoter quoter, IDescriptionGenerator descriptionGenerator, IOptions<GeneratorOptions> generatorOptions)

Parameters

Type	Name	Description
IColumn	column
IQuoter	quoter
IDescriptionGenerator	descriptionGenerator
IOptions<GeneratorOptions>	generatorOptions

SqlServer2005Generator(SqlServer2005Quoter)

Declaration

public SqlServer2005Generator(SqlServer2005Quoter quoter)

Parameters

Type	Name	Description
SqlServer2005Quoter	quoter

SqlServer2005Generator(SqlServer2005Quoter, IOptions<GeneratorOptions>)

Declaration

public SqlServer2005Generator(SqlServer2005Quoter quoter, IOptions<GeneratorOptions> generatorOptions)

Parameters

Type	Name	Description
SqlServer2005Quoter	quoter
IOptions<GeneratorOptions>	generatorOptions

Properties

AddColumn

Declaration

public override string AddColumn { get; }

Property Value

Type	Description
string

Overrides

SqlServer2000Generator.AddColumn

CreateForeignKeyConstraint

Declaration

public override string CreateForeignKeyConstraint { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.CreateForeignKeyConstraint

CreateIndex

Declaration

public override string CreateIndex { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.CreateIndex

CreateSchema

Declaration

public override string CreateSchema { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.CreateSchema

CreateUniqueConstraint

Declaration

public virtual string CreateUniqueConstraint { get; }

Property Value

Type	Description
string

DropIndex

Declaration

public override string DropIndex { get; }

Property Value

Type	Description
string

Overrides

SqlServer2000Generator.DropIndex

IdentityInsert

Declaration

public override string IdentityInsert { get; }

Property Value

Type	Description
string

Overrides

SqlServer2000Generator.IdentityInsert

Methods

Generate(AlterColumnExpression)

Generates a ALTER TABLE ALTER COLUMN SQL statement

Declaration

public override string Generate(AlterColumnExpression expression)

Parameters

Type	Name	Description
AlterColumnExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(AlterColumnExpression)

Generate(AlterSchemaExpression)

Generates an SQL statement to move a table from one schema to another

Declaration

public override string Generate(AlterSchemaExpression expression)

Parameters

Type	Name	Description
AlterSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(AlterSchemaExpression)

Generate(AlterTableExpression)

Generates a ALTER TABLE SQL statement

Declaration

public override string Generate(AlterTableExpression expression)

Parameters

Type	Name	Description
AlterTableExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GeneratorBase.Generate(AlterTableExpression)

Generate(CreateColumnExpression)

Generates a ALTER TABLE ADD COLUMN SQL statement

Declaration

public override string Generate(CreateColumnExpression expression)

Parameters

Type	Name	Description
CreateColumnExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateColumnExpression)

Generate(CreateConstraintExpression)

Generates an SQL statement to create a constraint

Declaration

public override string Generate(CreateConstraintExpression expression)

Parameters

Type	Name	Description
CreateConstraintExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

SqlServer2000Generator.Generate(CreateConstraintExpression)

Generate(CreateForeignKeyExpression)

Generates an SQL statement to create a foreign key

Declaration

public override string Generate(CreateForeignKeyExpression expression)

Parameters

Type	Name	Description
CreateForeignKeyExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateForeignKeyExpression)

Generate(CreateIndexExpression)

Generates an SQL statement to create an index

Declaration

public override string Generate(CreateIndexExpression expression)

Parameters

Type	Name	Description
CreateIndexExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateIndexExpression)

Generate(CreateSchemaExpression)

Generates a CREATE SCHEMA SQL statement

Declaration

public override string Generate(CreateSchemaExpression expression)

Parameters

Type	Name	Description
CreateSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateSchemaExpression)

Generate(CreateTableExpression)

Outputs a create table string

Declaration

public override string Generate(CreateTableExpression expression)

Parameters

Type	Name	Description
CreateTableExpression	expression

Returns

Type	Description
string

Overrides

GenericGenerator.Generate(CreateTableExpression)

Generate(DeleteConstraintExpression)

Generates an SQL statement to drop a constraint

Declaration

public override string Generate(DeleteConstraintExpression expression)

Parameters

Type	Name	Description
DeleteConstraintExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteConstraintExpression)

Generate(DeleteDefaultConstraintExpression)

Generates an SQL statement to drop a default constraint

Declaration

public override string Generate(DeleteDefaultConstraintExpression expression)

Parameters

Type	Name	Description
DeleteDefaultConstraintExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

SqlServer2000Generator.Generate(DeleteDefaultConstraintExpression)

Generate(DeleteIndexExpression)

Generates an SQL statement to drop an index

Declaration

public override string Generate(DeleteIndexExpression expression)

Parameters

Type	Name	Description
DeleteIndexExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteIndexExpression)

Generate(DeleteSchemaExpression)

Generates a DROP SCHEMA SQL statement

Declaration

public override string Generate(DeleteSchemaExpression expression)

Parameters

Type	Name	Description
DeleteSchemaExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteSchemaExpression)

Generate(DeleteTableExpression)

Generates a DROP TABLE SQL statement

Declaration

public override string Generate(DeleteTableExpression expression)

Parameters

Type	Name	Description
DeleteTableExpression	expression	The expression to create the SQL for

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteTableExpression)

GetFilterString(CreateConstraintExpression)

Declaration

public virtual string GetFilterString(CreateConstraintExpression createConstraintExpression)

Parameters

Type	Name	Description
CreateConstraintExpression	createConstraintExpression

Returns

Type	Description
string

GetFilterString(CreateIndexExpression)

Declaration

public virtual string GetFilterString(CreateIndexExpression createIndexExpression)

Parameters

Type	Name	Description
CreateIndexExpression	createIndexExpression

Returns

Type	Description
string

GetIncludeString(CreateConstraintExpression)

Declaration

public virtual string GetIncludeString(CreateConstraintExpression expression)

Parameters

Type	Name	Description
CreateConstraintExpression	expression

Returns

Type	Description
string

GetIncludeString(CreateIndexExpression)

Declaration

public virtual string GetIncludeString(CreateIndexExpression expression)

Parameters

Type	Name	Description
CreateIndexExpression	expression

Returns

Type	Description
string

GetIncludeStringFor(ISupportAdditionalFeatures, string)

Declaration

protected string GetIncludeStringFor(ISupportAdditionalFeatures expression, string featureKey)

Parameters

Type	Name	Description
ISupportAdditionalFeatures	expression
string	featureKey

Returns

Type	Description
string

GetWithOptions(ISupportAdditionalFeatures)

Declaration

public virtual string GetWithOptions(ISupportAdditionalFeatures expression)

Parameters

Type	Name	Description
ISupportAdditionalFeatures	expression

Returns

Type	Description
string

IsAdditionalFeatureSupported(string)

Declaration

public override bool IsAdditionalFeatureSupported(string feature)

Parameters

Type	Name	Description
string	feature

Returns

Type	Description
bool

Overrides

SqlServer2000Generator.IsAdditionalFeatureSupported(string)

Implements

IMigrationGenerator