Generate ef6 sql update script from code

Question

When I run update-database -Script from the Nuget Package Manager Console, Visual studio generates a SQL script which I can run to update the database.

Is there any way to generate this SQL script in C# without running it?

That way I can show it to the user who is updating the application before updating the database.

Try update-database -Verbose

WPInfo
– WPInfo

2018-02-26 07:53:07 +00:00
Commented Feb 26, 2018 at 7:53 — WPInfo
– WPInfo, Commented Feb 26, 2018 at 7:53

AlbertK · Accepted Answer · 2018-02-26 11:33:31Z

2

You can use DbMigrator and MigratorScriptingDecorator:

var configuration = new DbMigrationsConfiguration
{
    ContextType = typeof(ApplicationDbContext),
    MigrationsAssembly = typeof(ApplicationDbContext).Assembly,
    MigrationsNamespace = "YourNamespace.Migrations",
    AutomaticMigrationsEnabled = true
};
var dbMigrator = new DbMigrator(configuration);
var migratorScriptingDecorator = new MigratorScriptingDecorator(dbMigrator);
string script = migratorScriptingDecorator.ScriptUpdate(sourceMigration: null, targetMigration: null);

edited Feb 26, 2018 at 11:33

answered Feb 26, 2018 at 10:15

AlbertK

13.5k5 gold badges45 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generate ef6 sql update script from code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related