How to use migration programmatically in EntityFramework Codefirst?

Question

I'm working in a project that uses EF Code First. I'm trying to use migration features. I don't want to use Package Console Manager. How can I execute the "Add-Migration" and "Update-Database" programmatically?

add-migration TestMigration01 -force

update-database

Steve Greene · Accepted Answer · 2016-02-02 14:11:23Z

17

You have a couple of choices. You can use the dbmigrator class from within your code: http://romiller.com/2012/02/09/running-scripting-migrations-from-code/

Or you can use migrate.exe which is handy for running them in a build step, etc. https://msdn.microsoft.com/en-us/data/jj618307.aspx

answered Feb 2, 2016 at 14:11

Steve Greene

12.4k2 gold badges36 silver badges56 bronze badges

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

Comments

Charles · Accepted Answer · 2024-04-07 03:31:37Z

Solution for EF Core:

public static void AddMigration()
{
    var h1 = new OperationReportHandler(
        errorHandler: (x) =>
        {
            throw new Exception(x);
        },
        warningHandler: (x) => 
        {
            Debug.WriteLine($"Warn, {x}");
        });

    var reporter = new OperationReporter(h1);

    Assembly asm = asm; // your Assembly
    Assembly startupAsm = asm; // your Assembly

    var projName = "<project name here>";
    var subPath = $"Database\\_Migrations";

    string rootNS = projName; 
    string subNS = null; // overrides rootNS

    var solRoot = "<solution root here>";
    var projRoot = Path.Combine(solRoot.FullName, projName);

    var outputDir = Path.Combine(projRoot, subPath);

    var args = new string[0]; //  
    var nullable = false; // nullable Ref Types
    string language = null; // defaults to "C#"

    var sec = ((long)(DateTime.UtcNow - StartDate).TotalSeconds);
    var migrationName = $"M_{sec}"; // your Migration Name

    MigrationsOperations migrationsOperations = new MigrationsOperations(
        reporter,
        asm, startupAsm, projRoot, rootNS,
        language, nullable, args);

    var ctxType = typeof(DbContextCreator).FullName; // your ContextType here

    MigrationFiles migrationFiles =
        migrationsOperations.AddMigration(migrationName, outputDir, ctxType, snapshotNS);
}

private static DateTime StartDate = new DateTime(2024, 04, 01);

Install the Nuget for Microsoft.EntityFrameworkCore.Design.
Then adjust the .csproj

<PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.3">
  <PrivateAssets>all</PrivateAssets>
  <IncludeAssets></IncludeAssets>
</PackageReference>

You have to clear IncludeAssets to use the internal types of Microsoft.EntityFrameworkCore.Design.

I tried the code and it generates the same files as Package Manager Console:

Add-Migration -OutputDir Database\_Migrations -Context DbContextCreator

Update Database is just:

ctx.Database.Migrate();

Collectives™ on Stack Overflow

How to use migration programmatically in EntityFramework Codefirst?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related