SqlServerMigrationsSqlGenerator SqlServerMigrationsSqlGenerator Class

Definition

public class SqlServerMigrationsSqlGenerator : MigrationsSqlGenerator, IMigrationsSqlGenerator
Public Class SqlServerMigrationsSqlGenerator
    Inherits MigrationsSqlGenerator
    Implements IMigrationsSqlGenerator
Inheritance
System.ObjectSystem.Object
SqlServerMigrationsSqlGeneratorSqlServerMigrationsSqlGenerator
Implements

Inherited Members

Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator

Generate(System.Collections.Generic.IReadOnlyList<MigrationOperation>, IModel)Generate(System.Collections.Generic.IReadOnlyList(Of MigrationOperation), IModel)
SequenceOptions(System.String, System.String, System.Int32, System.Nullable<System.Int64>, System.Nullable<System.Int64>, System.Boolean, IModel, MigrationCommandListBuilder)SequenceOptions(System.String, System.String, System.Int32, System.Nullable(Of System.Int64), System.Nullable(Of System.Int64), System.Boolean, IModel, MigrationCommandListBuilder)
GetColumnType(System.String, System.String, System.String, System.Type, System.Nullable<System.Boolean>, System.Nullable<System.Int32>, System.Boolean, IModel)GetColumnType(System.String, System.String, System.String, System.Type, System.Nullable(Of System.Boolean), System.Nullable(Of System.Int32), System.Boolean, IModel)
DefaultValue(System.Object, System.String, MigrationCommandListBuilder)DefaultValue(System.Object, System.String, MigrationCommandListBuilder)
FindEntityTypes(IModel, System.String, System.String)FindEntityTypes(IModel, System.String, System.String)
FindProperty(IModel, System.String, System.String, System.String)FindProperty(IModel, System.String, System.String, System.String)
ColumnList(System.String[])ColumnList(System.String())

System.Object

System.Object.ToString()System.Object.ToString()
System.Object.Equals(System.Object)System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()System.Object.GetHashCode()
System.Object.GetType()System.Object.GetType()
System.Object.MemberwiseClone()System.Object.MemberwiseClone()

Constructors

SqlServerMigrationsSqlGenerator(IRelationalCommandBuilderFactory, ISqlGenerationHelper, IRelationalTypeMapper, IRelationalAnnotationProvider, IMigrationsAnnotationProvider) SqlServerMigrationsSqlGenerator(IRelationalCommandBuilderFactory, ISqlGenerationHelper, IRelationalTypeMapper, IRelationalAnnotationProvider, IMigrationsAnnotationProvider)

public SqlServerMigrationsSqlGenerator(IRelationalCommandBuilderFactory commandBuilderFactory, ISqlGenerationHelper sqlGenerationHelper, IRelationalTypeMapper typeMapper, IRelationalAnnotationProvider annotations, IMigrationsAnnotationProvider migrationsAnnotations)
Public Sub New(commandBuilderFactory As IRelationalCommandBuilderFactory, sqlGenerationHelper As ISqlGenerationHelper, typeMapper As IRelationalTypeMapper, annotations As IRelationalAnnotationProvider, migrationsAnnotations As IMigrationsAnnotationProvider)
Parameters

Methods

ColumnDefinition(String, String, String, Type, String, Nullable, Nullable, 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<System.Boolean> System.Nullable(Of System.Boolean)
maxLength
System.Nullable<System.Int32> System.Nullable(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
model
IModel IModel
Overrides

ColumnDefinition(String, String, String, Type, String, Nullable, Nullable, 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<System.Boolean> System.Nullable(Of System.Boolean)
maxLength
System.Nullable<System.Int32> System.Nullable(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
model
IModel IModel

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
property
IProperty IProperty

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
schema
System.String System.String
tableName
System.String System.String
columnName
System.String System.String

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
property
IProperty IProperty

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
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
terminate
System.Boolean System.Boolean
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
terminate
System.Boolean System.Boolean
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
terminate
System.Boolean System.Boolean
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
terminate
System.Boolean System.Boolean

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel
Overrides

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
model
IModel IModel

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
model
IModel IModel

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
model
IModel IModel
Overrides

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
name
System.String System.String
newName
System.String System.String

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
name
System.String System.String
newName
System.String System.String
type
System.String System.String

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
newSchema
System.String System.String
schema
System.String System.String
name
System.String System.String