Cannot Migrate Database

Question

Cannot Migrate Database

PocketPixie 21

Hello all,

I am having issue updating the migration of my database. I am currently using .NET 9.0. I have modified one of my files to include the following:

protected override void Up(MigrationBuilder migrationBuilder)

{

migrationBuilder.UpdateData(

table: "DiaryEntries",

keyColumn: "Id",

keyValue: 1,

column: "Created",

value: new DateTime(2024, 9, 16, 12, 6, 6, 691, DateTimeKind.Local).AddTicks(2342));

migrationBuilder.UpdateData(

table: "DiaryEntries",

keyColumn: "Id",

keyValue: 2,

column: "Created",

value: new DateTime(2024, 9, 16, 12, 6, 6, 691, DateTimeKind.Local).AddTicks(2642));

migrationBuilder.UpdateData(

table: "DiaryEntries",

keyColumn: "Id",

keyValue: 3,

column: "Created",

value: new DateTime(2024, 9, 16, 12, 6, 6, 691, DateTimeKind.Local).AddTicks(2646));

}

Unfortunately when I do add-migration AddedSeedingDataDiaryEntry

followed by update-database

it comes with this error message:

at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)

An error was generated for warning 'Microsoft.EntityFrameworkCore.Migrations.PendingModelChangesWarning': The model for context 'ApplicationDbContext' 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'.

How do I update the database to help with pending changes? I have already added the migration and I see the file there, but this error message makes it look like the migration was never added.

Olaf Helper 47,596 Reputation points

2024-09-16T16:31:25.0966667+00:00

Has nothing to do with SQL Server (your post tag), but with Entity Framework Code First.

Better use the right post tag.
PocketPixie 21 Reputation points

2024-09-18T16:03:33.9466667+00:00

Updated the tag. Thought it was for Microsoft SQL since it is dealing with the database.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

1 answer

Your answer

Olaf Helper 47,596 Reputation points

2024-09-16T16:31:25.0966667+00:00

Has nothing to do with SQL Server (your post tag), but with Entity Framework Code First.

Better use the right post tag.
PocketPixie 21 Reputation points

2024-09-18T16:03:33.9466667+00:00

Updated the tag. Thought it was for Microsoft SQL since it is dealing with the database.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

MikeyQiaoMSFT-0444 3,310

Hi，PocketPixie

Entity Framework Code isn't really my thing.

I've found the following link for you, the content inside might be of help to you.

https://stackoverflow.com/questions/70555317/multiple-level-properties-with-ef-core-6

Regards

Mikey Qiao

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.

David H 5 Reputation points

2024-09-18T15:27:51.5866667+00:00
I suspect you are having exactly that same problem as me - are you doing the Udemy course for MVC at the moment? I recognise some of that code...

I don't know what caused the problem - but I have managed to suppress the error message and get the migration to run properly:

Chain an extra method when you're setting up the dependency injection:

builder.Services.AddDbContext<ApplicationDbContext>(

options => options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")) **.ConfigureWarnings(warnings => warnings.Ignore(RelationalEventId.PendingModelChangesWarning**)));

PocketPixie 21

Hello thank you,

I have the problem solved now. Just needed this line of code that someone supplied. Looks very similar to yours:

usingMicrosoft.EntityFrameworkCore.Diagnostics; 
<snip> Builder.Services.AddDbContext<ApplicationDbContext>(    options => {        options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection"));        options.ConfigureWarnings(warnings => warnings.Ignore(RelationalEventId.PendingModelChangesWarning));    });

Share via

Cannot Migrate Database

1 answer

Your answer