SqlServerMigrationsSqlGenerator SqlServerMigrationsSqlGenerator Class

Syntax

Declaration

public class SqlServerMigrationsSqlGenerator : MigrationsSqlGenerator, IMigrationsSqlGeneratorPublic Class SqlServerMigrationsSqlGenerator
    Inherits MigrationsSqlGenerator
    Implements IMigrationsSqlGenerator

Inheritance Hierarchy

Inherited Members

SqlGenerationHelper,
SqlGenerationHelper,
TypeMapper,
TypeMapper,
Annotations,
Annotations,
Generate(IReadOnlyList<MigrationOperation>, IModel),
Generate(IReadOnlyList(Of MigrationOperation), IModel),
Generate(AddForeignKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(AddForeignKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(AddUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
Generate(AddUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
Generate(AlterSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(AlterSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(CreateSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(CreateSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(CreateTableOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(CreateTableOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropForeignKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropForeignKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropPrimaryKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropPrimaryKeyOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropSchemaOperation, IModel, MigrationCommandListBuilder),
Generate(DropSchemaOperation, IModel, MigrationCommandListBuilder),
Generate(DropSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(DropSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(DropTableOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropTableOperation, IModel, MigrationCommandListBuilder, Boolean),
Generate(DropUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
Generate(DropUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
Generate(RestartSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(RestartSequenceOperation, IModel, MigrationCommandListBuilder),
Generate(SqlOperation, IModel, MigrationCommandListBuilder),
Generate(SqlOperation, IModel, MigrationCommandListBuilder),
SequenceOptions(AlterSequenceOperation, IModel, MigrationCommandListBuilder),
SequenceOptions(AlterSequenceOperation, IModel, MigrationCommandListBuilder),
SequenceOptions(CreateSequenceOperation, IModel, MigrationCommandListBuilder),
SequenceOptions(CreateSequenceOperation, IModel, MigrationCommandListBuilder),
SequenceOptions(String, String, Int32, Nullable<Int64>, Nullable<Int64>, Boolean, IModel, MigrationCommandListBuilder),
SequenceOptions(String, String, Int32, Nullable(Of Int64), Nullable(Of Int64), Boolean, IModel, MigrationCommandListBuilder),
ColumnDefinition(AddColumnOperation, IModel, MigrationCommandListBuilder),
ColumnDefinition(AddColumnOperation, IModel, MigrationCommandListBuilder),
GetColumnType(String, String, String, Type, Nullable<Boolean>, Nullable<Int32>, Boolean, IModel),
GetColumnType(String, String, String, Type, Nullable(Of Boolean), Nullable(Of Int32), Boolean, IModel),
DefaultValue(Object, String, MigrationCommandListBuilder),
DefaultValue(Object, String, MigrationCommandListBuilder),
ForeignKeyConstraint(AddForeignKeyOperation, IModel, MigrationCommandListBuilder),
ForeignKeyConstraint(AddForeignKeyOperation, IModel, MigrationCommandListBuilder),
PrimaryKeyConstraint(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder),
PrimaryKeyConstraint(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder),
UniqueConstraint(AddUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
UniqueConstraint(AddUniqueConstraintOperation, IModel, MigrationCommandListBuilder),
FindEntityTypes(IModel, String, String),
FindEntityTypes(IModel, String, String),
FindProperty(IModel, String, String, String),
FindProperty(IModel, String, String, String),
EndStatement(MigrationCommandListBuilder, Boolean),
EndStatement(MigrationCommandListBuilder, Boolean),
ColumnList(String[]),
ColumnList(String()),
IsOldColumnSupported(IModel),
IsOldColumnSupported(IModel),
ToString(),
ToString(),
Equals(Object),
Equals(Object),
Equals(Object, Object),
Equals(Object, Object),
ReferenceEquals(Object, Object),
ReferenceEquals(Object, Object),
GetHashCode(),
GetHashCode(),
GetType(),
GetType(),
MemberwiseClone()
MemberwiseClone()

Constructors summary

Methods summary

Constructors

Methods

  • ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)
    ColumnDefinition(String, String, String, Type, String, Nullable(Of Boolean), Nullable(Of Int32), Boolean, Boolean, Object, String, String, IAnnotatable, IModel, MigrationCommandListBuilder)
    protected override void ColumnDefinition(string schema, string table, string name, Type clrType, string type, bool ? unicode, int ? maxLength, bool rowVersion, bool nullable, object defaultValue, string defaultValueSql, string computedColumnSql, IAnnotatable annotatable, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub ColumnDefinition(schema As String, table As String, name As String, clrType As Type, type As String, unicode As Boolean?, maxLength As Integer?, rowVersion As Boolean, nullable As Boolean, defaultValue As Object, defaultValueSql As String, computedColumnSql As String, annotatable As IAnnotatable, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

    • schema
      System.String
      System.String
    • table
      System.String
      System.String
    • name
      System.String
      System.String
    • clrType
      System.Type
      System.Type
    • type
      System.String
      System.String
    • unicode
      System.Nullable<T><System.Boolean>
      System.Nullable<T>(Of System.Boolean)
    • maxLength
      System.Nullable<T><System.Int32>
      System.Nullable<T>(Of System.Int32)
    • rowVersion
      System.Boolean
      System.Boolean
    • nullable
      System.Boolean
      System.Boolean
    • defaultValue
      System.Object
      System.Object
    • defaultValueSql
      System.String
      System.String
    • computedColumnSql
      System.String
      System.String
    • annotatable
    • model
    • builder
  • ColumnDefinition(String, String, String, Type, String, Nullable<Boolean>, Nullable<Int32>, Boolean, Boolean, Object, String, String, Boolean, IAnnotatable, IModel, MigrationCommandListBuilder)
    ColumnDefinition(String, String, String, Type, String, Nullable(Of Boolean), Nullable(Of Int32), Boolean, Boolean, Object, String, String, Boolean, IAnnotatable, IModel, MigrationCommandListBuilder)
    protected virtual void ColumnDefinition(string schema, string table, string name, Type clrType, string type, bool ? unicode, int ? maxLength, bool rowVersion, bool nullable, object defaultValue, string defaultValueSql, string computedColumnSql, bool identity, IAnnotatable annotatable, IModel model, MigrationCommandListBuilder builder)Protected Overridable Sub ColumnDefinition(schema As String, table As String, name As String, clrType As Type, type As String, unicode As Boolean?, maxLength As Integer?, rowVersion As Boolean, nullable As Boolean, defaultValue As Object, defaultValueSql As String, computedColumnSql As String, identity As Boolean, annotatable As IAnnotatable, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

    • schema
      System.String
      System.String
    • table
      System.String
      System.String
    • name
      System.String
      System.String
    • clrType
      System.Type
      System.Type
    • type
      System.String
      System.String
    • unicode
      System.Nullable<T><System.Boolean>
      System.Nullable<T>(Of System.Boolean)
    • maxLength
      System.Nullable<T><System.Int32>
      System.Nullable<T>(Of System.Int32)
    • rowVersion
      System.Boolean
      System.Boolean
    • nullable
      System.Boolean
      System.Boolean
    • defaultValue
      System.Object
      System.Object
    • defaultValueSql
      System.String
      System.String
    • computedColumnSql
      System.String
      System.String
    • identity
      System.Boolean
      System.Boolean
    • annotatable
    • model
    • builder
  • CreateIndexes(IProperty, MigrationCommandListBuilder)
    CreateIndexes(IProperty, MigrationCommandListBuilder)
    protected virtual void CreateIndexes(IProperty property, MigrationCommandListBuilder builder)Protected Overridable Sub CreateIndexes(property As IProperty, builder As MigrationCommandListBuilder)

    Parameters

  • DropDefaultConstraint(String, String, String, MigrationCommandListBuilder)
    DropDefaultConstraint(String, String, String, MigrationCommandListBuilder)
    protected virtual void DropDefaultConstraint(string schema, string tableName, string columnName, MigrationCommandListBuilder builder)Protected Overridable Sub DropDefaultConstraint(schema As String, tableName As String, columnName As String, builder As MigrationCommandListBuilder)

    Parameters

  • DropIndexes(IProperty, MigrationCommandListBuilder)
    DropIndexes(IProperty, MigrationCommandListBuilder)
    protected virtual void DropIndexes(IProperty property, MigrationCommandListBuilder builder)Protected Overridable Sub DropIndexes(property As IProperty, builder As MigrationCommandListBuilder)

    Parameters

  • ForeignKeyAction(ReferentialAction, MigrationCommandListBuilder)
    ForeignKeyAction(ReferentialAction, MigrationCommandListBuilder)
    protected override void ForeignKeyAction(ReferentialAction referentialAction, MigrationCommandListBuilder builder)Protected Overrides Sub ForeignKeyAction(referentialAction As ReferentialAction, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AddColumnOperation, IModel, MigrationCommandListBuilder)
    Generate(AddColumnOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AddColumnOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AddColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AddColumnOperation, IModel, MigrationCommandListBuilder, Boolean)
    Generate(AddColumnOperation, IModel, MigrationCommandListBuilder, Boolean)
    protected override void Generate(AddColumnOperation operation, IModel model, MigrationCommandListBuilder builder, bool terminate)Protected Overrides Sub Generate(operation As AddColumnOperation, model As IModel, builder As MigrationCommandListBuilder, terminate As Boolean)

    Parameters

  • Generate(AddForeignKeyOperation, IModel, MigrationCommandListBuilder)
    Generate(AddForeignKeyOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AddForeignKeyOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AddForeignKeyOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder)
    Generate(AddPrimaryKeyOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AddPrimaryKeyOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AddPrimaryKeyOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AlterColumnOperation, IModel, MigrationCommandListBuilder)
    Generate(AlterColumnOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AlterColumnOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AlterColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AlterDatabaseOperation, IModel, MigrationCommandListBuilder)
    Generate(AlterDatabaseOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AlterDatabaseOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AlterDatabaseOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(AlterTableOperation, IModel, MigrationCommandListBuilder)
    Generate(AlterTableOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(AlterTableOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As AlterTableOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(CreateIndexOperation, IModel, MigrationCommandListBuilder)
    Generate(CreateIndexOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(CreateIndexOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As CreateIndexOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(CreateIndexOperation, IModel, MigrationCommandListBuilder, Boolean)
    Generate(CreateIndexOperation, IModel, MigrationCommandListBuilder, Boolean)
    protected override void Generate(CreateIndexOperation operation, IModel model, MigrationCommandListBuilder builder, bool terminate)Protected Overrides Sub Generate(operation As CreateIndexOperation, model As IModel, builder As MigrationCommandListBuilder, terminate As Boolean)

    Parameters

  • Generate(CreateTableOperation, IModel, MigrationCommandListBuilder)
    Generate(CreateTableOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(CreateTableOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As CreateTableOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(DropColumnOperation, IModel, MigrationCommandListBuilder)
    Generate(DropColumnOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(DropColumnOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As DropColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(DropColumnOperation, IModel, MigrationCommandListBuilder, Boolean)
    Generate(DropColumnOperation, IModel, MigrationCommandListBuilder, Boolean)
    protected override void Generate(DropColumnOperation operation, IModel model, MigrationCommandListBuilder builder, bool terminate)Protected Overrides Sub Generate(operation As DropColumnOperation, model As IModel, builder As MigrationCommandListBuilder, terminate As Boolean)

    Parameters

  • Generate(DropForeignKeyOperation, IModel, MigrationCommandListBuilder)
    Generate(DropForeignKeyOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(DropForeignKeyOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As DropForeignKeyOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(DropIndexOperation, IModel, MigrationCommandListBuilder)
    Generate(DropIndexOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(DropIndexOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As DropIndexOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(DropIndexOperation, IModel, MigrationCommandListBuilder, Boolean)
    Generate(DropIndexOperation, IModel, MigrationCommandListBuilder, Boolean)
    protected virtual void Generate(DropIndexOperation operation, IModel model, MigrationCommandListBuilder builder, bool terminate)Protected Overridable Sub Generate(operation As DropIndexOperation, model As IModel, builder As MigrationCommandListBuilder, terminate As Boolean)

    Parameters

  • Generate(DropPrimaryKeyOperation, IModel, MigrationCommandListBuilder)
    Generate(DropPrimaryKeyOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(DropPrimaryKeyOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As DropPrimaryKeyOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(DropTableOperation, IModel, MigrationCommandListBuilder)
    Generate(DropTableOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(DropTableOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As DropTableOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(EnsureSchemaOperation, IModel, MigrationCommandListBuilder)
    Generate(EnsureSchemaOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(EnsureSchemaOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As EnsureSchemaOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(MigrationOperation, IModel, MigrationCommandListBuilder)
    Generate(MigrationOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As MigrationOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(RenameColumnOperation, IModel, MigrationCommandListBuilder)
    Generate(RenameColumnOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(RenameColumnOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As RenameColumnOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(RenameIndexOperation, IModel, MigrationCommandListBuilder)
    Generate(RenameIndexOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(RenameIndexOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As RenameIndexOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(RenameSequenceOperation, IModel, MigrationCommandListBuilder)
    Generate(RenameSequenceOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(RenameSequenceOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As RenameSequenceOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(RenameTableOperation, IModel, MigrationCommandListBuilder)
    Generate(RenameTableOperation, IModel, MigrationCommandListBuilder)
    protected override void Generate(RenameTableOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub Generate(operation As RenameTableOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(SqlServerCreateDatabaseOperation, IModel, MigrationCommandListBuilder)
    Generate(SqlServerCreateDatabaseOperation, IModel, MigrationCommandListBuilder)
    protected virtual void Generate(SqlServerCreateDatabaseOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overridable Sub Generate(operation As SqlServerCreateDatabaseOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Generate(SqlServerDropDatabaseOperation, IModel, MigrationCommandListBuilder)
    Generate(SqlServerDropDatabaseOperation, IModel, MigrationCommandListBuilder)
    protected virtual void Generate(SqlServerDropDatabaseOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overridable Sub Generate(operation As SqlServerDropDatabaseOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • IndexTraits(MigrationOperation, IModel, MigrationCommandListBuilder)
    IndexTraits(MigrationOperation, IModel, MigrationCommandListBuilder)
    protected override void IndexTraits(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)Protected Overrides Sub IndexTraits(operation As MigrationOperation, model As IModel, builder As MigrationCommandListBuilder)

    Parameters

  • Rename(String, String, MigrationCommandListBuilder)
    Rename(String, String, MigrationCommandListBuilder)
    protected virtual void Rename(string name, string newName, MigrationCommandListBuilder builder)Protected Overridable Sub Rename(name As String, newName As String, builder As MigrationCommandListBuilder)

    Parameters

  • Rename(String, String, String, MigrationCommandListBuilder)
    Rename(String, String, String, MigrationCommandListBuilder)
    protected virtual void Rename(string name, string newName, string type, MigrationCommandListBuilder builder)Protected Overridable Sub Rename(name As String, newName As String, type As String, builder As MigrationCommandListBuilder)

    Parameters

  • Transfer(String, String, String, MigrationCommandListBuilder)
    Transfer(String, String, String, MigrationCommandListBuilder)
    protected virtual void Transfer(string newSchema, string schema, string name, MigrationCommandListBuilder builder)Protected Overridable Sub Transfer(newSchema As String, schema As String, name As String, builder As MigrationCommandListBuilder)

    Parameters

Details

Assembly

Microsoft.EntityFrameworkCore.SqlServer.dll