efmigrations.md

EntityFramework Migrations

EntityFramework Migrations are supported.

var sqlInstance = new SqlInstance<MyDbContext>(
    buildTemplate: async (connection, options) =>
    {

        options.ReplaceService<IMigrationsSqlGenerator, MigrationsGenerator>();

        await using var data = new MyDbContext(options.Options);
        await data.Database.MigrateAsync();

    },
    constructInstance: builder => new(builder.Options));

^{snippet source | anchor}

The above performs the following actions:

Custom Migrations Operations

Optionally use Custom Migrations Operations.

options.ReplaceService<IMigrationsSqlGenerator, MigrationsGenerator>();

^{snippet source | anchor}

Apply the migration

Perform a Runtime apply of migrations.

await using var data = new MyDbContext(options.Options);
await data.Database.MigrateAsync();

^{snippet source | anchor}