System.Data.Entity.SqlServer.SqlServerMigrationSqlGenerator.Generate C# (CSharp) Method

Generate() public method

Converts a set of migration operations into Microsoft SQL Server specific SQL.
public Generate ( IEnumerable migrationOperations, string providerManifestToken ) : IEnumerable
migrationOperations IEnumerable The operations to be converted.
providerManifestToken string Token representing the version of SQL Server being targeted (i.e. "2005", "2008").
return IEnumerable
        public override IEnumerable<MigrationStatement> Generate(
            IEnumerable<MigrationOperation> migrationOperations, string providerManifestToken)
        {
            Check.NotNull(migrationOperations, "migrationOperations");
            Check.NotNull(providerManifestToken, "providerManifestToken");

            _statements = new List<MigrationStatement>();
            _generatedSchemas = new HashSet<string>();

            InitializeProviderServices(providerManifestToken);
            GenerateStatements(migrationOperations);

            return _statements;
        }

Same methods

SqlServerMigrationSqlGenerator::Generate ( DateTime defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( DateTimeOffset defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Spatial.DbGeography defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Spatial.DbGeometry defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( Guid defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( TimeSpan defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( bool defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( byte defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( object defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( string defaultValue ) : string
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AddColumnOperation addColumnOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AddForeignKeyOperation addForeignKeyOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AddPrimaryKeyOperation addPrimaryKeyOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AlterColumnOperation alterColumnOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AlterProcedureOperation alterProcedureOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.AlterTableOperation alterTableOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.ColumnModel column, System.Data.Entity.Migrations.Utilities.IndentedTextWriter writer ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.CreateIndexOperation createIndexOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.CreateProcedureOperation createProcedureOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.CreateTableOperation createTableOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropColumnOperation dropColumnOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropForeignKeyOperation dropForeignKeyOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropIndexOperation dropIndexOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropPrimaryKeyOperation dropPrimaryKeyOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropProcedureOperation dropProcedureOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.DropTableOperation dropTableOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.HistoryOperation historyOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( HistoryRebuildOperationSequence sequence ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.MigrationOperation migrationOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.MoveProcedureOperation moveProcedureOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.MoveTableOperation moveTableOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.ParameterModel parameterModel, System.Data.Entity.Migrations.Utilities.IndentedTextWriter writer ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.ProcedureOperation procedureOperation, string modifier ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.RenameColumnOperation renameColumnOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.RenameIndexOperation renameIndexOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.RenameProcedureOperation renameProcedureOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.RenameTableOperation renameTableOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.SqlOperation sqlOperation ) : void
SqlServerMigrationSqlGenerator::Generate ( System.Data.Entity.Migrations.Model.UpdateDatabaseOperation updateDatabaseOperation ) : void

Usage Example

        public void Generate_can_output_statement_to_drop_foreign_key_operation()
        {
            var migrationSqlGenerator = new SqlServerMigrationSqlGenerator();

            var operation =
                new DropForeignKeyOperation
                {
                    Name = "FK_na'me",
                    DependentTable = "sch'ema.DependentTable"
                };

            var sql = migrationSqlGenerator.Generate(new [] { operation }, SqlProviderManifest.TokenAzure11)
                .Join(s => s.Sql, Environment.NewLine);

            const string expectedSql =
@"IF object_id(N'[sch''ema].[FK_na''me]', N'F') IS NOT NULL
    ALTER TABLE [sch'ema].[DependentTable] DROP CONSTRAINT [FK_na'me]";

            Assert.Equal(expectedSql, sql);
        }
All Usage Examples Of System.Data.Entity.SqlServer.SqlServerMigrationSqlGenerator::Generate