nopCommerce-4.10 - Fetch data from SQL via SQL query and Stored Procedure via plugin is not working

Cannot create a DbSet for 'CLASSMODEL' because this type is not included in the model for the context.

using Nop.Core;

namespace Nop.Plugin.Shipping.FixedByWeightByTotal.Model
{
    /// <summary>
    /// Represents a shipping by weight record
    /// </summary>
    public partial class ShippingRecordModel :BaseEntity
    {
        /// <summary>
        /// Gets or sets the store identifier
        /// </summary>
        public int StoreId { get; set; }

        /// <summary>
        /// Gets or sets the warehouse identifier
        /// </summary>
        public int WarehouseId { get; set; }

        /// <summary>
        /// Gets or sets the country identifier
        /// </summary>
        public int CountryId { get; set; }                
    }
}

/// <summary>
        /// Creates a LINQ query for the query type based on a raw SQL query
        /// </summary>
        /// <typeparam name="TQuery">Query type</typeparam>
        /// <param name="sql">The raw SQL query</param>
        /// <returns>An IQueryable representing the raw SQL query</returns>
        public virtual IQueryable<TQuery> QueryFromSql<TQuery>(string sql) where TQuery : class
        {
            return this.Query<TQuery>().FromSql(sql);
        }

        /// <summary>
        /// Creates a LINQ query for the entity based on a raw SQL query
        /// </summary>
        /// <typeparam name="TEntity">Entity type</typeparam>
        /// <param name="sql">The raw SQL query</param>
        /// <param name="parameters">The values to be assigned to parameters</param>
        /// <returns>An IQueryable representing the raw SQL query</returns>
        public virtual IQueryable<TEntity> EntityFromSql<TEntity>(string sql, params object[] parameters) where TEntity : BaseEntity
        {
            return this.Set<TEntity>().FromSql(CreateSqlWithParameters(sql, parameters), parameters);
        }

        /// <summary>
        /// Modify the input SQL query by adding passed parameters
        /// </summary>
        /// <param name="sql">The raw SQL query</param>
        /// <param name="parameters">The values to be assigned to parameters</param>
        /// <returns>Modified raw SQL query</returns>
        protected virtual string CreateSqlWithParameters(string sql, params object[] parameters)
        {
            //add parameters to sql
            for (var i = 0; i <= (parameters?.Length ?? 0) - 1; i++)
            {
                if (!(parameters is DbParameter parameter))
                    continue;

                sql = $"{sql}{(i > 0 ? "," : string.Empty)} @{parameter.ParameterName}";

                //whether parameter is output
                if (parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Output)
                    sql = $"{sql} output";
            }

            return sql;
        }

  //override required repository with our custom context
            builder.RegisterType<ShippingRecordModel>().As<ShippingRecordModel>()
                .WithParameter(ResolvedParameter.ForNamed<IDbContext>("nop_object_context_shipping_weight_total_zip"))
                .InstancePerLifetimeScope();

IList<ShippingRecordModel> GetAllBySQL();

     private readonly ShippingByWeightByTotalObjectContext _dbContext = EngineContext.Current.Resolve<ShippingByWeightByTotalObjectContext>();

     public virtual IList<ShippingRecordModel> GetAllBySQL()
        {
            var aa = _dbContext.QueryFromSql<ShippingRecordModel>("SELECT StoreId,WarehouseId,CountryId  FROM ShippingMethod").ToList();

            return aa;
        }

 var allData = _shippingByWeightService.GetAllBySQL();

modelBuilder.Query<ShippingRecordModel>();

   protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.ApplyConfiguration(new ShippingByWeightByTotalRecordMap());
           
            // For Execute SQL Query
            modelBuilder.Query<ShippingRecordModel>();
            base.OnModelCreating(modelBuilder);
        }

 //override required repository with our custom context
            builder.RegisterType<ShippingRecordModel>().As<ShippingRecordModel>()
                .WithParameter(ResolvedParameter.ForNamed<IDbContext>("nop_object_context_shipping_weight_total_zip"))
                .InstancePerLifetimeScope();

_dbContext.QueryFromSql<ShippingRecordModel>("SELECT StoreId,WarehouseId,CountryId  FROM ShippingByWeightByTotalRecord").ToList();

_dbContext.Query<ShippingRecordModel>().FromSql("SELECT StoreId, WarehouseId, CountryId FROM ShippingByWeightByTotalRecord").ToList();

modelBuilder.Query<ShippingRecordModel>();

   protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.ApplyConfiguration(new ShippingByWeightByTotalRecordMap());
           
            // For Execute SQL Query
            modelBuilder.Query<ShippingRecordModel>();
            base.OnModelCreating(modelBuilder);
        }

 //override required repository with our custom context
            builder.RegisterType<ShippingRecordModel>().As<ShippingRecordModel>()
                .WithParameter(ResolvedParameter.ForNamed<IDbContext>("nop_object_context_shipping_weight_total_zip"))
                .InstancePerLifetimeScope();

_dbContext.QueryFromSql<ShippingRecordModel>("SELECT StoreId,WarehouseId,CountryId  FROM ShippingByWeightByTotalRecord").ToList();

_dbContext.Query<ShippingRecordModel>().FromSql("SELECT StoreId, WarehouseId, CountryId FROM ShippingByWeightByTotalRecord").ToList();

_dbContext.Query<CLASSNAME>().FromSql("SPNAME",
                   parameter1, parameter2, ...);