Unnecessary migration is generated after update to 8.0.2 about pomelo.entityframeworkcore.mysql HOT 5 CLOSED

The snapshot has the following differences

// <auto-generated />
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
+using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;

#nullable disable

namespace WebApi.Migrations
{
    [DbContext(typeof(AppDbContext))]
    partial class AppDbContextModelSnapshot : ModelSnapshot
    {
        protected override void BuildModel(ModelBuilder modelBuilder)
        {
#pragma warning disable 612, 618
            modelBuilder
-                .HasAnnotation("ProductVersion", "7.0.18")
+                .HasAnnotation("ProductVersion", "8.0.4")
                .HasAnnotation("Relational:MaxIdentifierLength", 64);

+            MySqlModelBuilderExtensions.AutoIncrementColumns(modelBuilder);
+
            modelBuilder.Entity("Blog", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int");

+                    MySqlPropertyBuilderExtensions.UseMySqlIdentityColumn(b.Property<int>("Id"));
+
                    b.Property<string>("Name")
                        .IsRequired()
                        .HasMaxLength(100)
                        .HasColumnType("varchar(100)");

                    b.HasKey("Id");

                    b.ToTable("Blogs");
                });
#pragma warning restore 612, 618
        }
    }
}

from pomelo.entityframeworkcore.mysql.

I'm sorry. It was a duplicate, so I'll Close it.
Only snapshots are updated.
This is handled by deleting the contents of the migration script.

#1895

from pomelo.entityframeworkcore.mysql.

I am sorry but what exactly was the solution? What rows did you delete, the
MySqlModelBuilderExtensions.AutoIncrementColumns(modelBuilder);
?
And then the altercolumns ?

I am having the same issue and I have made 0 code change except migrating to new version of dotnet.

from pomelo.entityframeworkcore.mysql.

@Todilo

The following procedure was used to update the software.

This work assumes that there are no changes involving intentional migration to Entity before and after the Pomello version upgrade; do not include any work other than the Pomello version upgrade.

• 1. upgrade to Pomello 8.0.2
• 2. create a new empty migration (this will add unnecessary migration scripts for the Id column and update the current snapshot)
• 3. delete all of Up and Down, since Entity does not contain any intentional migrations and the migration scripts added in 2 are not needed. Leave the Snapshot as it is important.
• 4. update the database locally just to be sure and verify that no DDLs of any kind are issued.

from pomelo.entityframeworkcore.mysql.

@Todilo

The following procedure was used to update the software.

This work assumes that there are no changes involving intentional migration to Entity before and after the Pomello version upgrade; do not include any work other than the Pomello version upgrade.

• 1. upgrade to Pomello 8.0.2
• 2. create a new empty migration (this will add unnecessary migration scripts for the Id column and update the current snapshot)
• 3. delete all of Up and Down, since Entity does not contain any intentional migrations and the migration scripts added in 2 are not needed. Leave the Snapshot as it is important.
• 4. update the database locally just to be sure and verify that no DDLs of any kind are issued.

Thank you @karuakun ! Works great!

from pomelo.entityframeworkcore.mysql.