How to run sql script with Entity Framework in .NET Core 1.0?

Question

I'd like to run sql scripts in an ASP.NET MVC Core 1.0 project. The answer here: Can we run sql script using code first migrations? pretty much explains exactly what I want to do, except that for this line:

Sql(File.ReadAllText(sqlFile));

it barks and says "The name 'Sql' does not exist in the current context". I'm sure there must be a way in .NET Core 1.0. I'm just getting started with .NET Core 1.0, so it may be something simple that I'm missing.

Konstantin Tarkus · Accepted Answer · 2016-06-10 14:36:05Z

11

private class SomeMigration : Migration
{
    protected override void Up(MigrationBuilder migrationBuilder)
    {
        migrationBuilder.Sql(File.ReadAllText(sqlFile));
    }

    protected override void Down(MigrationBuilder migrationBuilder)
    {
    }
}

answered Jun 10, 2016 at 14:36

Konstantin Tarkus

38.6k14 gold badges137 silver badges123 bronze badges

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

1 Comment

Adrian Carr Over a year ago

Sweet. That worked great. In case anyone else comes across it, I did have to remove the "GO" statements from my script for it to work. Thanks @Konstantin!

Collectives™ on Stack Overflow

How to run sql script with Entity Framework in .NET Core 1.0?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related