MySQL Implementation Code about blazor-starter-kit HOT 4 CLOSED

    protected` override void OnModelCreating(ModelBuilder builder)
    {
        foreach (var property in builder.Model.GetEntityTypes()
        .SelectMany(t => t.GetProperties())
        .Where(p => p.ClrType == typeof(decimal) || p.ClrType == typeof(decimal?)))
        {
            property.SetColumnType("decimal(18,2)");
        }
        
        foreach (var property in builder.Model.GetEntityTypes()
            .SelectMany(t => t.GetProperties())
            .Where(p => p.Name is "LastModifiedBy" or "CreatedBy"))
        {
            property.SetColumnType("nvarchar(128)");
        }
        
        base.OnModelCreating(builder);
        builder.Entity<ChatHistory<BlazorHeroUser>>(entity =>
        {
            entity.ToTable("ChatHistory");

            entity.HasOne(d => d.FromUser)
                .WithMany(p => p.ChatHistoryFromUsers)
                .HasForeignKey(d => d.FromUserId)
                .OnDelete(DeleteBehavior.ClientSetNull);

            entity.HasOne(d => d.ToUser)
                .WithMany(p => p.ChatHistoryToUsers)
                .HasForeignKey(d => d.ToUserId)
                .OnDelete(DeleteBehavior.ClientSetNull);
        });

        builder.Entity<BlazorHeroUser>(entity =>
        {
            entity.ToTable(name: "Users");
            entity.Property(e => e.Id).ValueGeneratedOnAdd();
        });
        builder.Entity<BlazorHeroUser>(entity => entity.Property(m => m.Id).HasMaxLength(200));
        builder.Entity<BlazorHeroUser>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(200));
        builder.Entity<BlazorHeroUser>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(200));

        builder.Entity<BlazorHeroRole>(entity =>
        {
            entity.ToTable(name: "Roles");
        });
        builder.Entity<BlazorHeroRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(200));
        builder.Entity<BlazorHeroRole>(entity => entity.Property(m => m.Id).HasMaxLength(200));

        builder.Entity<IdentityUserRole<string>>(entity =>
        {
            entity.ToTable("UserRoles");
        });
        builder.Entity<IdentityUserRole<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(200));
        builder.Entity<IdentityUserRole<string>>(entity => entity.Property(m => m.RoleId).HasMaxLength(200));

        builder.Entity<IdentityUserClaim<string>>(entity =>
        {
            entity.ToTable("UserClaims");
        });
        builder.Entity<IdentityUserClaim<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(200));

        builder.Entity<IdentityUserLogin<string>>(entity =>
        {
            entity.ToTable("UserLogins");
        });
        builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(200));
        builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.LoginProvider).HasMaxLength(200));
        builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.ProviderKey).HasMaxLength(200));

        builder.Entity<BlazorHeroRoleClaim>(entity =>
        {
            entity.ToTable(name: "RoleClaims");
            entity.HasOne(d => d.Role)
                .WithMany(p => p.RoleClaims)
                .HasForeignKey(d => d.RoleId)
                .OnDelete(DeleteBehavior.Cascade);
        });
        builder.Entity<BlazorHeroRoleClaim>(entity => entity.Property(m => m.RoleId).HasMaxLength(200));

        builder.Entity<IdentityUserToken<string>>(entity =>
        {
            entity.ToTable("UserTokens");
        });
        builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(200));
        builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.LoginProvider).HasMaxLength(200));
        builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.Name).HasMaxLength(200));
    }

    `services.AddHangfire(x => x.UseStorage(new MySqlStorage(_configuration.GetConnectionString("DefaultConnection"))));`

    `using Hangfire.MySql.Core;`