entity framework execute SQL before migrations

Question

I am working on an existing project that uses Entity-Framework 6 with code-first. I have a need to run some SQL before the migrations run.

I have a DbMigrationsConfiguration class with a seed method, but seed runs after the migrations.

I think it will work if I run my SQL in the constructor but I can't get a reference to the context.

Does anyone know how to do this?

Uchitha · Accepted Answer · 2014-10-25 22:34:43Z

26

You could use the 'Sql' method within the desired migration class.

public partial class OneOfYourMigrations : DbMigration 
{ 
    public override void Up() 
    { 
        //EF generated migration code here such as
        //CreateTable or AddColumn etc...
        //Now run your custom sql - here I'm doing an update to an existing column
        Sql("UPDATE dbo.YourTable SET Column1 = 'VALUE1' "); 
    } 

    public override void Down() 
    { 
        //EF generated code to rollback
    } 
}

So the steps are;

Generate migration class using Add-Migration
Alter the class using code similar to above
Run the migration using Update-Database

answered Oct 25, 2014 at 22:34

Uchitha

1,05810 silver badges25 bronze badges

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

3 Comments

Don Chambers Over a year ago

Can you explain more detail? I thought migrations run once and only once. This would work if it will run every time but it only seems to run one time.

Uchitha Over a year ago

May be I could be more specific if I knew what kind of SQL you want to run? Is it modification of data (like I mentioned above) or is it something else? FYI, a given migration runs once against a given db, but you can always roll back a given migration - change it (i.e Add Sql) and run it again.

JackMorrissey Over a year ago

Want to run a script? stackoverflow.com/questions/32125937/…

Collectives™ on Stack Overflow

entity framework execute SQL before migrations

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related