CODEWITHSUNDEEP
c#sql.netentity-framework
Adrian Carr
Adrian Carr

Reputation: 3133

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

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.

Upvotes: 5

Views: 5530

Answers (1)

Konstantin Tarkus
Konstantin Tarkus

Reputation: 38428

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

    protected override void Down(MigrationBuilder migrationBuilder)
    {
    }
}

Upvotes: 11

Related Questions