Query Support in entity framework core 3.1

[KamranShahid]

I am using .net core 3.1 application in which i have referenced entity framework core 3.1.8 and using various tables via model first approach. (db is mysql)
Now I need some custom join query where i have to run manual queries.
I am trying code from #1862

public static class SqlQueryExtensions
    {
        public static IList<T> SqlQuery<T>(this DbContext db, string sql, params object[] parameters) where T : class
        {
            using (var db2 = new ContextForQueryType<T>(db.Database.GetDbConnection()))
            {
                return db2.Set<T>().FromSqlRaw(sql, parameters).ToList();
            }
        }

        private class ContextForQueryType<T> : DbContext where T : class
        {
            private readonly DbConnection connection;

            public ContextForQueryType(DbConnection connection)
            {
                this.connection = connection;
            }

            protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
            {
                optionsBuilder.UseSqlServer(connection, options => options.EnableRetryOnFailure());

                base.OnConfiguring(optionsBuilder);
            }

            protected override void OnModelCreating(ModelBuilder modelBuilder)
            {
                modelBuilder.Entity<T>().HasNoKey();
                base.OnModelCreating(modelBuilder);
            }
        }
    }

but it is not compiling.
Please suggest is it related to nuget package difference or what?

[ErikEJ]

You probably need to change this line to use the MySQL provider (I am in the blind here, since you are not sharing any information about the build errors):

 optionsBuilder.UseSqlServer(connection, options => options.EnableRetryOnFailure());

A production hardened version of this class is available here: https://github.com/ErikEJ/EFCorePowerTools/blob/master/src/GUI/RevEng.Core/DbContextExtensions