MySQL Implementation Code

[ricardopdv]

I don´t know where to share code so i'm doing here.
add MySql.EntityFrameworkCore nuget package to Infrastructure project and Web/Server project

Code changes to use MySQL

Source/Infrasctructure/Contexts/BlazorHeroContext.cs:

       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)");
            }
            base.OnModelCreating(builder);
            builder.Entity<ChatHistory>(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");
            });

            builder.Entity<IdentityRole>(entity =>
            {
                entity.ToTable(name: "Roles");
            });
            builder.Entity<IdentityUserRole<string>>(entity =>
            {
                entity.ToTable("UserRoles");
            });

            builder.Entity<IdentityUserClaim<string>>(entity =>
            {
                entity.ToTable("UserClaims");
            });

            builder.Entity<IdentityUserLogin<string>>(entity =>
            {
                entity.ToTable("UserLogins");
            });

            builder.Entity<IdentityRoleClaim<string>>(entity =>
            {
                entity.ToTable("RoleClaims");
            });

            builder.Entity<IdentityUserToken<string>>(entity =>
            {
                entity.ToTable("UserTokens");
            });

            builder.Entity<IdentityUser>(entity => entity.Property(m => m.Id).HasMaxLength(85));
            builder.Entity<IdentityUser>(entity => entity.Property(m => m.NormalizedEmail).HasMaxLength(85));
            builder.Entity<IdentityUser>(entity => entity.Property(m => m.NormalizedUserName).HasMaxLength(85));

            builder.Entity<IdentityRole>(entity => entity.Property(m => m.Id).HasMaxLength(85));
            builder.Entity<IdentityRole>(entity => entity.Property(m => m.NormalizedName).HasMaxLength(85));

            builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
            builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.ProviderKey).HasMaxLength(85));
            builder.Entity<IdentityUserLogin<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(85));
            builder.Entity<IdentityUserRole<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(85));

            builder.Entity<IdentityUserRole<string>>(entity => entity.Property(m => m.RoleId).HasMaxLength(85));

            builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(85));
            builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.LoginProvider).HasMaxLength(85));
            builder.Entity<IdentityUserToken<string>>(entity => entity.Property(m => m.Name).HasMaxLength(85));

            builder.Entity<IdentityUserClaim<string>>(entity => entity.Property(m => m.Id).HasMaxLength(85));
            builder.Entity<IdentityUserClaim<string>>(entity => entity.Property(m => m.UserId).HasMaxLength(85));

            builder.Entity<IdentityRoleClaim<string>>(entity => entity.Property(m => m.Id).HasMaxLength(85));
            builder.Entity<IdentityRoleClaim<string>>(entity => entity.Property(m => m.RoleId).HasMaxLength(85));
        }

Server/Extensions/ServiceCollectionExtensions.cs

        public static IServiceCollection AddDatabase(
            this IServiceCollection services,
            IConfiguration configuration)
            => services
                .AddDbContext<BlazorHeroContext>(options => options
                    .UseMySQL(configuration.GetConnectionString("DefaultConnection"))
                  //.UseSqlServer(configuration.GetConnectionString("DefaultConnection"))
                  )
            .AddTransient<IDatabaseSeeder, DatabaseSeeder>();

Wish is helpful !!

[iammukeshm]

cool, i will add this to the guide in a while. thanks! I hope you liked this project,

[chhinsras]

cool. if there is switchable option in the setting.

[erdikalleci]

I am trying. But I am getting error "Integrated Security". Has anyone encountered this error? What is the reason? I searched but couldn't find a solution.

[fpieragostini]

I would like to share MySQL Implementation to get the right table names in BlazorHeroContext.cs file and the code change for hangfire.

The first one change in BlazorHeroContext.cs

    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));
    }

The second one for startup.cs

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

add the namespace

    `using Hangfire.MySql.Core;` 

You have to sure to install the Hangfire.MySql.Core package in Server and Infrastructure project.

Thanks to @ricardopdv for the first comment and special thanks to @iammukeshm for the BlazorHero Boilerplate!

F.