Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) The method 'OrderB...

The method 'OrderByDescending' cannot follow the method 'Select' or is not supported. in plugin

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello experts ,

I'am facing the following :The method 'OrderByDescending' cannot follow the method 'Select' or is not supported. Try writing the query in terms of supported methods or call the 'AsEnumerable' or 'ToList' method before calling unsupported methods when using a plugin.

var PrestationPrice = (from pricePrest
in context1.pricePrestSet
where pricePrest.pricelistgroupid == oppProdu.pricelistgroupid &&
pricePrest.hotelid== oppProdu.hotelid
&& (pricePrest.validit_start_date <= oppProdu.start_date.Value.AddDays(1) && pricePrest.rea_validit_end_date >= oppProdu.start_date.Value.AddDays(1))
select new { pricePrest.adultprice, pricePrest.childprice }).OrderByDescending(p => p.adultprice).ThenByDescending(e => e.childprice).ToList();

productPrice = PrestationPrice.First().adultprice.Value;
productPrice = PrestationPrice.First().childprice.Value;

Thank you

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: The method 'OrderByDescending' cannot follow the method 'Select' or is not supported. in plugin

Hi Clément,

I did manage this by adding the order by to my query.
Verified answer

Clem 2,541 on at

Like (1)

Report
RE: The method 'OrderByDescending' cannot follow the method 'Select' or is not supported. in plugin

Hello,

As the stack says did you try to perform the following :

var PrestationPrice = (Your Query).ToList().OrderByDescending(p => p.adultprice).ThenByDescending(e => e.childprice);

I think the issue here is that ThenByDescending is just not supported from a IEnumerable variable.

Clément