Class SqlServer2000Generator

Inheritance

SqlServer2000Generator

SqlServer2005Generator

SqlServerCeGenerator

Implements

IMigrationGenerator

Inherited Members

GenericGenerator.compatabilityMode

GenericGenerator.CompatibilityMode

GenericGenerator.CreateTable

GenericGenerator.DropTable

GenericGenerator.DropColumn

GenericGenerator.AlterColumn

GenericGenerator.CreateSchema

GenericGenerator.AlterSchema

GenericGenerator.DropSchema

GenericGenerator.CreateIndex

GenericGenerator.InsertData

GenericGenerator.UpdateData

GenericGenerator.DeleteData

GenericGenerator.DeleteConstraint

GenericGenerator.CreateForeignKeyConstraint

GenericGenerator.GetUniqueString(CreateIndexExpression)

GenericGenerator.Generate(CreateTableExpression)

GenericGenerator.Generate(DeleteTableExpression)

GenericGenerator.Generate(CreateColumnExpression)

GenericGenerator.Generate(AlterColumnExpression)

GenericGenerator.Generate(CreateIndexExpression)

GenericGenerator.Generate(DeleteIndexExpression)

GenericGenerator.Generate(CreateForeignKeyExpression)

GenericGenerator.Generate(DeleteConstraintExpression)

GenericGenerator.GenerateForeignKeyName(ForeignKeyDefinition)

GenericGenerator.Generate(DeleteForeignKeyExpression)

GenericGenerator.AppendSqlStatementEndToken(StringBuilder)

GenericGenerator.GenerateColumnNamesAndValues(InsertDataExpression)

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

GenericGenerator.Generate(UpdateDataExpression)

GenericGenerator.Generate(DeleteDataExpression)

GenericGenerator.Generate(CreateSchemaExpression)

GenericGenerator.Generate(DeleteSchemaExpression)

GenericGenerator.Generate(AlterSchemaExpression)

GeneratorBase.Generate(AlterTableExpression)

GeneratorBase.Column

GeneratorBase.Quoter

GeneratorBase.DescriptionGenerator

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: FluentMigrator.Runner.Generators.SqlServer

Assembly: FluentMigrator.Runner.SqlServer.dll

Syntax

public class SqlServer2000Generator : GenericGenerator, IMigrationGenerator

Constructors

| Edit this page View Source

SqlServer2000Generator()

Declaration

public SqlServer2000Generator()

| Edit this page View Source

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

Declaration

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

Parameters

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

| Edit this page View Source

SqlServer2000Generator(SqlServer2000Quoter)

Declaration

public SqlServer2000Generator(SqlServer2000Quoter quoter)

Parameters

Type	Name	Description
SqlServer2000Quoter	quoter

| Edit this page View Source

SqlServer2000Generator(SqlServer2000Quoter, IOptions<GeneratorOptions>)

Declaration

public SqlServer2000Generator(SqlServer2000Quoter quoter, IOptions<GeneratorOptions> generatorOptions)

Parameters

Type	Name	Description
SqlServer2000Quoter	quoter
IOptions<GeneratorOptions>	generatorOptions

Properties

| Edit this page View Source

AddColumn

Declaration

public override string AddColumn { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.AddColumn

| Edit this page View Source

CreateConstraint

Declaration

public override string CreateConstraint { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.CreateConstraint

| Edit this page View Source

DropIndex

Declaration

public override string DropIndex { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.DropIndex

| Edit this page View Source

IdentityInsert

Declaration

public virtual string IdentityInsert { get; }

Property Value

Type	Description
string

| Edit this page View Source

RenameColumn

Declaration

public override string RenameColumn { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.RenameColumn

| Edit this page View Source

RenameTable

Declaration

public override string RenameTable { get; }

Property Value

Type	Description
string

Overrides

GenericGenerator.RenameTable

Methods

| Edit this page View Source

BuildDelete(DeleteColumnExpression, string, StringBuilder)

Declaration

protected virtual void BuildDelete(DeleteColumnExpression expression, string columnName, StringBuilder builder)

Parameters

Type	Name	Description
DeleteColumnExpression	expression
string	columnName
StringBuilder	builder

| Edit this page View Source

Generate(AlterDefaultConstraintExpression)

Generates an SQL statement to alter a DEFAULT constraint

Declaration

public override string Generate(AlterDefaultConstraintExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GeneratorBase.Generate(AlterDefaultConstraintExpression)

| Edit this page View Source

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

GenericGenerator.Generate(CreateConstraintExpression)

| Edit this page View Source

Generate(CreateSequenceExpression)

Generates a CREATE SEQUENCE SQL statement

Declaration

public override string Generate(CreateSequenceExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(CreateSequenceExpression)

| Edit this page View Source

Generate(DeleteColumnExpression)

Generates a ALTER TABLE DROP COLUMN SQL statement

Declaration

public override string Generate(DeleteColumnExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteColumnExpression)

| Edit this page View Source

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

GeneratorBase.Generate(DeleteDefaultConstraintExpression)

| Edit this page View Source

Generate(DeleteSequenceExpression)

Generates a DROP SEQUENCE SQL statement

Declaration

public override string Generate(DeleteSequenceExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(DeleteSequenceExpression)

| Edit this page View Source

Generate(InsertDataExpression)

Generates an SQL statement to INSERT data

Declaration

public override string Generate(InsertDataExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(InsertDataExpression)

| Edit this page View Source

Generate(RenameColumnExpression)

Generates an SQL statement to rename a column

Declaration

public override string Generate(RenameColumnExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(RenameColumnExpression)

| Edit this page View Source

Generate(RenameTableExpression)

Generates an SQL statement to rename a table

Declaration

public override string Generate(RenameTableExpression expression)

Parameters

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

Returns

Type	Description
string	The generated SQL

Overrides

GenericGenerator.Generate(RenameTableExpression)

| Edit this page View Source

GetClusterTypeString(CreateIndexExpression)

Declaration

public override string GetClusterTypeString(CreateIndexExpression column)

Parameters

Type	Name	Description
CreateIndexExpression	column

Returns

Type	Description
string

Overrides

GenericGenerator.GetClusterTypeString(CreateIndexExpression)

| Edit this page View Source

GetConstraintClusteringString(CreateConstraintExpression)

Declaration

protected virtual string GetConstraintClusteringString(CreateConstraintExpression constraint)

Parameters

Type	Name	Description
CreateConstraintExpression	constraint

Returns

Type	Description
string

| Edit this page View Source

IsAdditionalFeatureSupported(string)

Declaration

public override bool IsAdditionalFeatureSupported(string feature)

Parameters

Type	Name	Description
string	feature

Returns

Type	Description
bool

Overrides

GeneratorBase.IsAdditionalFeatureSupported(string)

| Edit this page View Source

IsUsingIdentityInsert(InsertDataExpression)

Declaration

protected static bool IsUsingIdentityInsert(InsertDataExpression expression)

Parameters

Type	Name	Description
InsertDataExpression	expression

Returns

Type	Description
bool

Implements

IMigrationGenerator