efcore: Unexpected PendingModelChangesWarning on initial creation of database via migrations

When the entity config doesn’t include OwnsMany the error does not occur. his can be toggled with INCLUDE_ACCOUNT_HOLDERS: remove INCLUDE_ACCOUNT_HOLDERS as a compile-time constant from Domain and Infrastructure and the error does not occur.

I could not reproduce when everything was in a single project.

Steps to reproduce:

  1. git clone -b main --depth 1 https://github.com/peteraritchie/EfPendingModelChangesWarning.git
  2. cd EfPendingModelChangesWarning/src
  3. dotnet ef migrations add InitialCreate --startup-project Api --project Infrastructure
  4. dotnet ef database update --startup-project Api --project Infrastructure

Include your code

See steps and https://github.com/peteraritchie/EfPendingModelChangesWarning

Include stack traces

Output from dotnet ef database update:

System.InvalidOperationException: An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'AccountSqliteDbContext' has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID 'RelationalEventId.PendingModelChangesWarning' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.
   at Microsoft.EntityFrameworkCore.Diagnostics.EventDefinition`1.Log[TLoggerCategory](IDiagnosticsLogger`1 logger, TParam arg)
   at Microsoft.EntityFrameworkCore.Diagnostics.RelationalLoggerExtensions.PendingModelChangesWarning(IDiagnosticsLogger`1 diagnostics, Type contextType)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'AccountSqliteDbContext' has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID 'RelationalEventId.PendingModelChangesWarning' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.

Include verbose output

Verbose output from dotnet ef --verbose migrations add InitialCreate --startup-project Api --project Infrastructure

Using project 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj'.
Using startup project 'C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\peter\AppData\Local\Temp\tmpbpsjyc.tmp /verbosity:quiet /nologo C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\peter\AppData\Local\Temp\tmpsuql5r.tmp /verbosity:quiet /nologo C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj
Build started...
dotnet build C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj /verbosity:quiet /nologo /p:PublishAot=false
C:\Users\peter\src\experiment\DDDReference\src\Domain\PostalAddress.cs(5,16): warning CS8618: Non-nullable property 'Street' must contain a non-null value when exiting constructor. Consider adding the 'required' modifier or declaring the property as nullable. [C:\Users\peter\src\experiment\DDDReference\src\Domain\Pri.DDDReference.Domain.csproj]

Build succeeded.

C:\Users\peter\src\experiment\DDDReference\src\Domain\PostalAddress.cs(5,16): warning CS8618: Non-nullable property 'Street' must contain a non-null value when exiting constructor. Consider adding the 'required' modifier or declaring the property as nullable. [C:\Users\peter\src\experiment\DDDReference\src\Domain\Pri.DDDReference.Domain.csproj]
    1 Warning(s)
    0 Error(s)

Time Elapsed 00:00:06.83

Build succeeded.
dotnet exec --depsfile C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.deps.json --additionalprobingpath C:\Users\peter\.nuget\packages --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --additionalprobingpath "C:\Program Files\dotnet\sdk\NuGetFallbackFolder" --runtimeconfig C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.runtimeconfig.json C:\Users\peter\.dotnet\tools\.store\dotnet-ef\9.0.0\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll migrations add InitialCreate --assembly C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Infrastructure.dll --project C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj --startup-assembly C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.dll --startup-project C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj --project-dir C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\ --root-namespace Pri.DDDReference.Infrastructure --language C# --framework net8.0 --nullable --working-dir C:\Users\peter\src\experiment\DDDReference\src --verbose
Using assembly 'Pri.DDDReference.Infrastructure'.
Using startup assembly 'Pri.DDDReference.Api'.
Using application base 'C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0'.
Using working directory 'C:\Users\peter\src\experiment\DDDReference\src\Api'.
Using root namespace 'Pri.DDDReference.Infrastructure'.
Using project directory 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Finding DbContext classes in the project...
Found DbContext 'AccountSqliteDbContext'.
Finding application service provider in assembly 'Pri.DDDReference.Api'...
Finding Microsoft.Extensions.Hosting service provider...
Using environment 'Development'.
Using application service provider from Microsoft.Extensions.Hosting.
Using context 'AccountSqliteDbContext'.
Finding design-time services referenced by assembly 'Pri.DDDReference.Api'...
Finding design-time services referenced by assembly 'Pri.DDDReference.Infrastructure'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.Sqlite'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.Sqlite'.
Finding IDesignTimeServices implementations in assembly 'Pri.DDDReference.Api'...
No design-time services were found.
Writing migration to 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Migrations\20241114183900_InitialCreate.cs'.
Writing model snapshot to 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Migrations\AccountSqliteDbContextModelSnapshot.cs'.
Done. To undo this action, use 'ef migrations remove'

verbose output from dotnet ef --verbose database update --startup-project Api --project Infrastructure

Using project 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj'.
Using startup project 'C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj'.
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\peter\AppData\Local\Temp\tmpshmzoi.tmp /verbosity:quiet /nologo C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj
dotnet msbuild /target:GetEFProjectMetadata /property:EFProjectMetadataFile=C:\Users\peter\AppData\Local\Temp\tmprm3hs3.tmp /verbosity:quiet /nologo C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj
Build started...
dotnet build C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj /verbosity:quiet /nologo /p:PublishAot=false

Build succeeded.
    0 Warning(s)
    0 Error(s)

Time Elapsed 00:00:03.15

Build succeeded.
dotnet exec --depsfile C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.deps.json --additionalprobingpath C:\Users\peter\.nuget\packages --additionalprobingpath "C:\Program Files (x86)\Microsoft Visual Studio\Shared\NuGetPackages" --additionalprobingpath "C:\Program Files\dotnet\sdk\NuGetFallbackFolder" --runtimeconfig C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.runtimeconfig.json C:\Users\peter\.dotnet\tools\.store\dotnet-ef\9.0.0\dotnet-ef\9.0.0\tools\net8.0\any\tools\netcoreapp2.0\any\ef.dll database update --assembly C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Infrastructure.dll --project C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\Pri.DDDReference.Infrastructure.csproj --startup-assembly C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0\Pri.DDDReference.Api.dll --startup-project C:\Users\peter\src\experiment\DDDReference\src\Api\Pri.DDDReference.Api.csproj --project-dir C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\ --root-namespace Pri.DDDReference.Infrastructure --language C# --framework net8.0 --nullable --working-dir C:\Users\peter\src\experiment\DDDReference\src --verbose
Using assembly 'Pri.DDDReference.Infrastructure'.
Using startup assembly 'Pri.DDDReference.Api'.
Using application base 'C:\Users\peter\src\experiment\DDDReference\src\Api\bin\Debug\net8.0'.
Using working directory 'C:\Users\peter\src\experiment\DDDReference\src\Api'.
Using root namespace 'Pri.DDDReference.Infrastructure'.
Using project directory 'C:\Users\peter\src\experiment\DDDReference\src\Infrastructure\'.
Remaining arguments: .
Finding DbContext classes...
Finding IDesignTimeDbContextFactory implementations...
Finding DbContext classes in the project...
Found DbContext 'AccountSqliteDbContext'.
Finding application service provider in assembly 'Pri.DDDReference.Api'...
Finding Microsoft.Extensions.Hosting service provider...
Using environment 'Development'.
Using application service provider from Microsoft.Extensions.Hosting.
Using context 'AccountSqliteDbContext'.
Finding design-time services referenced by assembly 'Pri.DDDReference.Api'...
Finding design-time services referenced by assembly 'Pri.DDDReference.Infrastructure'...
No referenced design-time services were found.
Finding design-time services for provider 'Microsoft.EntityFrameworkCore.Sqlite'...
Using design-time services from provider 'Microsoft.EntityFrameworkCore.Sqlite'.
Finding IDesignTimeServices implementations in assembly 'Pri.DDDReference.Api'...
No design-time services were found.
System.InvalidOperationException: An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'AccountSqliteDbContext' has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID 'RelationalEventId.PendingModelChangesWarning' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.
   at Microsoft.EntityFrameworkCore.Diagnostics.EventDefinition`1.Log[TLoggerCategory](IDiagnosticsLogger`1 logger, TParam arg)
   at Microsoft.EntityFrameworkCore.Diagnostics.RelationalLoggerExtensions.PendingModelChangesWarning(IDiagnosticsLogger`1 diagnostics, Type contextType)
   at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
   at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'AccountSqliteDbContext' has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID 'RelationalEventId.PendingModelChangesWarning' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.

Include provider and version information

EF Core version: 9.0.0 (first reproduced with 8.0.10 Database provider: Microsoft.EntityFrameworkCore.Sqlite 9.0.0 Target framework: NET 8.0 Operating system: Windows IDE: Visual Studio 2022 17.12.0

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Reactions: 8
  • Comments: 37 (10 by maintainers)

Commits related to this issue

Most upvoted comments

System.InvalidOperationException: ‘An error was generated for warning ‘Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning’: The model for context ‘AppDbContext’ has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID ‘RelationalEventId.PendingModelChangesWarning’ to the ‘ConfigureWarnings’ method in ‘DbContext.OnConfiguring’ or ‘AddDbContext’.’

and when i run add-migration updateToNet9 -c AppDbContext

using  Microsoft.EntityFrameworkCore.Migrations;

namespace App.Data.Migrations
{
    /// <inheritdoc />
    public partial class updateToNet9 : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {

        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {

        }
    }
}

Wow, Not sure why this basic bugs got leaked into stable released version?

I’m also facing this error. Root cause for me is OnModelCreating function, I’m generating seed data for db. Seed generation code using DateTime.Now, Guid.NewGuid, and Ulid.NewUlid.

When I changed the dynamic values to static, it is fixed. Hope, you come up with better comparison mechanism to detect pending changes.

I have a similar error. Going back to ef 8 solve it

.NET 9 messed a lot of things up…

I’m having the same issue. After upgrading my project from .NET 8 to .NET 9, I ran into this migration problem. Everything worked fine in .NET 8, but as soon as I moved the codebase to a new repository and upgraded it to .NET 9, the issue popped up. I’ve already tried deleting the old migration files and creating new ones, but the error keeps showing up.

appDbContext.Database.Migrate();

System.InvalidOperationException: 'An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'dbContext' has pending changes. Add a 
new migration before updating the database. This exception can be suppressed or logged by passing event ID 
'RelationalEventId.PendingModelChangesWarning' to the 'ConfigureWarnings' method in 'DbContext.OnConfiguring' or 'AddDbContext'.'

Possible fix until this issue is resolved: .ConfigureWarnings(w => w.Ignore(RelationalEventId.PendingModelChangesWarning))

My team and I were testing out this example branch, we updated the postgres to use external sql server database (not containers - localhost)

We updated this work around for this BUG:

        //services.AddDbContext<OrderingContext>(options =>
        //{
        //    options.UseNpgsql(builder.Configuration.GetConnectionString("orderingdb"));
        //});
        //builder.EnrichNpgsqlDbContext<OrderingContext>();

        builder.AddSqlServerDbContext<OrderingContext>(
            "orderingdb", configureDbContextOptions: dbContextOptionsBuilder =>
            {
                dbContextOptionsBuilder.UseSqlServer();
                dbContextOptionsBuilder.ConfigureWarnings(
                    warnings => warnings.Ignore(RelationalEventId.PendingModelChangesWarning));
            });

System.InvalidOperationException: ‘An error was generated for warning ‘Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning’: The model for context ‘AppDbContext’ has pending changes. Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID ‘RelationalEventId.PendingModelChangesWarning’ to the ‘ConfigureWarnings’ method in ‘DbContext.OnConfiguring’ or ‘AddDbContext’.’

and when i run add-migration updateToNet9 -c AppDbContext

using  Microsoft.EntityFrameworkCore.Migrations;

namespace App.Data.Migrations
{
    /// <inheritdoc />
    public partial class updateToNet9 : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {

        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {

        }
    }
}

I’m getting the same error, not sure how to resolve this;

command after Initial script was generated: dotnet ef database update --startup-project …/Ordering.API --context OrderingContext

…" Add a new migration before updating the database. This exception can be suppressed or logged by passing event ID ‘RelationalEventId.PendingModelChangesWarning’ to the ‘ConfigureWarnings’ method in ‘DbContext.OnConfiguring’ or ‘AddDbContext’."

@hahn-kev @baoduy We still haven’t found where’s the bug. Please create and share a small runnable project that throws this exception even after adding a migration.

I have the same issue. I found that the problem lies in the entity.HasData method when I am seeding data. When I remove this method, the issue no longer occurs. Here is the link to my project https://github.com/dong-nguyen-hd/management-my-cv

I have a similar error. Going back to ef 8 solve it

I have same problem, i upgrade to .net 9 and when start Program.cs to execute migrate, a have same error

@peteraritchie Thanks for testing this–it confirms this is a bug in EF8/EF9. I will let @AndriySvyryd decide if he needs more info.

@pastrasigns Do you still get it after adding a new migration?

@AndriySvyryd Yes, even after adding the new migration

The exception still thrown in Migrate() method

baseDbContext.Database.EnsureDeleted();
baseDbContext.Database.Migrate();

I try to use dotnet ef update command and it works fine and all migrations applied to the database after that I tried to use baseDbContext.Database.Migrate(); without using EnsureDeleted() and it’s still thrown the exceptions.

To debug further, I checked the status of migrations using:

baseDbContext.Database.GetPendingMigrations();
baseDbContext.Database.GetAppliedMigrations();
baseDbContext.Database.Migrate();

so the GetPendingMigrations() method returned empty and GetAppliedMigrations() count 49 which is the list of migrations which supposed to work fine but it throws in baseDbContext.Database.Migrate();

Finally, as a workaround, I configured warnings to suppress the PendingModelChangesWarning exception:

options.ConfigureWarnings(warnings => { warnings.Log(Microsoft.EntityFrameworkCore.Diagnostics.RelationalEventId.PendingModelChangesWarning); });

And that’s worked

Note: we’ve just published https://github.com/dotnet/efcore/issues/35285 which provides more background and explanations around the new PendingModelChangesWarning; anyone still having trouble should go read that - hopefully it should help.

So EF Core has long standing bug of always reporting pending changes for keys (it is already reported) and now we have exception when there are pending changes. One added to another leads to – exception always.

Updated, link to the issue I mentioned: ef migrations add keep add the same AlterColumn migration content for strongly-typed primary key

We’re blocked with this issue as well.

@bharathm03 That case is covered by #35080.

My team and I were testing out this example branch, we updated the postgres to use external sql server database (not containers - localhost)

We updated this work around for this BUG:

        //services.AddDbContext<OrderingContext>(options =>
        //{
        //    options.UseNpgsql(builder.Configuration.GetConnectionString("orderingdb"));
        //});
        //builder.EnrichNpgsqlDbContext<OrderingContext>();

        builder.AddSqlServerDbContext<OrderingContext>(
            "orderingdb", configureDbContextOptions: dbContextOptionsBuilder =>
            {
                dbContextOptionsBuilder.UseSqlServer();
                dbContextOptionsBuilder.ConfigureWarnings(
                    warnings => warnings.Ignore(RelationalEventId.PendingModelChangesWarning));
            });

Interesting, thanks. But this issue shows an example using Sqlite. Switching to SqlServer from Postgres isn’t really a workaround. What am I missing?

I have the same issue

@pastrasigns Do you still get it after adding a new migration?

@peteraritchie Can you run dotnet ef migrations add Two --startup-project Api --project Infrastructure or similar immediately after adding the first migration? If the Up and Down methods in the second migration are not empty, can you post the contents here?