Entity Framework Core 2.2 : Disable migrations for specific entities

Question

I'm trying to build an aspnetcore application over an existing system where the database is already created, and I'm going to add some tables over it.

I've reverse engineered the database to add the existing tables as entities to my application, and I've written my own entities that will be added later. Finally, all the entities are added to a single DbContext.

My requirement comes as follows:

• I want to enable code first migrations for the newly added entities
• I don't want the migrations to occur for the already existing tables/entities

Note: I prefer not to touch the generated migration code.

Is there a proper way to handle this scenario?

Answer 1

Is there a proper way to handle this scenario?

Editing the Migration Code is a proper way to handle this scenario.

Alternatively, you could create one DbContext with Migrations containing only the Entities mapped to Tables you want to manage using Migrations. Then create another DbContext with all the Entities which is used to read and write to the database.

Note here that your Migration Context may lack Navigation Properties, containing only the corresponding Foreign Key Properties if you don't want to add real Foreign Keys in the database refering to tables not controlled by your Migrations.

Answer 2

You can ignore the entity if the entity builder is called after Add-Migration operation by examining the command line arguments;

public void Configure(EntityTypeBuilder<YourEntity> builder)
{
    //all properties to be mapped...

    //ignored when adding a new migration
    builder.HasOne(p => p.EntityDetail)
        .WithOne()
        .HasForeignKey<Entity>(x => x.Id)
        .IsRequired(false);

    if (MigrationHelper.IsMigrationOperationExecuting())
        builder.Ignore(x => x.EntityDetail);
}

public static class MigrationHelper
{
    public static bool IsMigrationOperationExecuting()
    {
        var commandLineArguments = Environment.GetCommandLineArgs();
        string[] orderedMigrationArguments = { "migrations", "add" };

        for (var i = 0; i <= commandLineArguments.Length - orderedMigrationArguments.Length; i++)
        {
            if (commandLineArguments.Skip(i).Take(orderedMigrationArguments.Length).SequenceEqual(orderedMigrationArguments))
                return true;
        }

        return false;
    }
}