private static EntityDataServiceResponse <ProductVariant> GetProductVariants(GetProductVariantsDataRequest request)
            {
                PagedResult <ProductVariant> variants;

                using (SqliteDatabaseContext context = new SqliteDatabaseContext(request.RequestContext))
                {
                    string languageId = request.RequestContext.GetChannelConfiguration().DefaultLanguageId;
                    GetProductVariantsProcedure getVariantsProcedure = new GetProductVariantsProcedure(context, languageId, request.QueryResultSettings);
                    variants = getVariantsProcedure.Execute(request.ItemAndInventoryDimensionIds);
                }

                return(new EntityDataServiceResponse <ProductVariant>(variants));
            }
            private ReadOnlyCollection <ProductVariant> GetProductVariants(SqliteDatabaseContext context, TempTable assortedProducts)
            {
                GetProductVariantsProcedure getVariantsProcedure = new GetProductVariantsProcedure(context, this.request.LanguageId, QueryResultSettings.AllRecords);

                return(getVariantsProcedure.Execute(assortedProducts).Results);
            }