Stored Procedure in Nop Commerce

  public virtual IPagedList<GetTopProduct> GetProductCategoriesByCategoryId(int categoryId,
             int pageIndex = 0, int pageSize = int.MaxValue)
        {
            if (categoryId == 0)
                return new PagedList<GetTopProduct>(new List<GetTopProduct>(), pageIndex, pageSize);


            int totalCount = 0;
            var pCategoryIds = _dataProvider.GetParameter();
            pCategoryIds.ParameterName = "CategoryId";
            pCategoryIds.Value = categoryId;
            pCategoryIds.DbType = DbType.Int32;

            var pPageIndex = _dataProvider.GetParameter();
            pPageIndex.ParameterName = "PageIndex";
            pPageIndex.Value = pageIndex;
            pPageIndex.DbType = DbType.Int32;

            var pPageSize = _dataProvider.GetParameter();
            pPageSize.ParameterName = "PageSize";
            pPageSize.Value = pageSize;
            pPageSize.DbType = DbType.Int32;

            var product = _dbContext.ExecuteStoredProcedureList<GetTopProduct>("GetProductByTopCategoryId", pCategoryIds,pPageIndex,pPageSize);
            //var query = from tcm in _topCategoriesMappingRepository.Table
            //            join p in _productRepo.Table on tcm.ProductId equals p.Id
            //            where tcm.TopCategoriesId == categoryId &&
            //                      !p.Deleted &&
            //                      (showHidden || p.Published)
            //            select tcm ;
            if (product != null && product.Count > 0)
                totalCount = product.ToList().FirstOrDefault().TotalCount;


            return new PagedList<GetTopProduct>(product, pageIndex, pageSize,totalCount);
        }