Custom Entity Framework Core Migration Script?

Question

I need to make a "full-text indexed" but I am using ef core 2.1 code first migration, but Full Indexes do not have first class support in core.

How can I write my own migration that would be applied while the other generated migrations are being applied?

migrationBuilder.Sql method is your friend. For more info, see Migrations and API Reference. — Ivan Stoev
– Ivan Stoev, Commented Jun 26, 2018 at 17:38
So, I generate the migration file then go in and manually change it or do I make a another file? — chobo2
– chobo2, Commented Jun 26, 2018 at 17:40
Manually change it. Your use-case with Full-Text Search is even mentioned in the Empty Migrations part of the first documentation link. — Ivan Stoev
– Ivan Stoev, Commented Jun 26, 2018 at 17:42
This was answered in your Github issue Full Text Search in EF Core 2.1 and an example was provided your in SO question How to use FreeText in EF core 2.1. — Mark G
– Mark G, Commented Jun 27, 2018 at 1:26

Vivek Nuna · Accepted Answer · 2018-06-27 07:25:06Z

5

You have to create empty migration and then in Up method you can write your SQL query.

Create Empty Migration by running Add-Migration command in Package Manager Console.
Add the SQL function in Up method like the following way.

public partial class your_migration_name : Migration {

protected override void Up(MigrationBuilder migrationBuilder)
{
    migrationBuilder.Sql(@"<YourQuery>");
}

protected override void Down(MigrationBuilder migrationBuilder)
{
    migrationBuilder.Sql(@"Drop <YourQuery>");
}
}

Run Update-Database in Package Manager Console.

answered Jun 27, 2018 at 7:25

Vivek Nuna

30.6k34 gold badges162 silver badges259 bronze badges

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

Collectives™ on Stack Overflow

Custom Entity Framework Core Migration Script?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related