This question is locked. New answers and comments are not allowed.
Hello,
today i have installed the new Q3 release...now my code does not work anymore (before Q3 it worked!)...
Following error is thrown:
Linq statement is following:
Why and where should i use a integer???!!!
regards
Richard.
today i have installed the new Q3 release...now my code does not work anymore (before Q3 it worked!)...
Following error is thrown:
An exception occured during the execution of '
Extent<
Web.PORDER
>().Where(po => ((((((po.PORDER_S_KEY == value(Klassen.clPRIN+<>c__DisplayClass47).sOrderKey) AndAlso ((Convert(po.PORDER_B_LOCKED) == null) OrElse (Convert(po.PORDER_B_LOCKED) == Convert(0)))) AndAlso ((po.PORDER_D_FROM == Convert(null)) OrElse (po.PORDER_D_FROM <
Convert
(DateTime.Now)))) AndAlso ((po.PORDER_D_TO == Convert(null)) OrElse (po.PORDER_D_TO > Convert(DateTime.Now.Date)))) AndAlso ((Convert(po.PORDER_B_NIGHT) == Convert(1)) OrElse (value(Klassen.clPRIN+<>c__DisplayClass47).bNightmode == False))) AndAlso value(Klassen.clPRIN+<>c__DisplayClass47).lOrdertypes.Contains(po.PORDER_I_TYPE))).Count()'.
Failure: Directly parameterized literal boolean eq/neq expression found; use integer type here.
Linq statement is following:
lOrdertypes is a List<
short
?>
bNightmode is a boolean
var query = from po in iclDB.dbContext.PORDERs
where po.PORDER_S_KEY == sOrderKey && (po.PORDER_B_LOCKED == null || po.PORDER_B_LOCKED == 0) &&
(po.PORDER_D_FROM == null || po.PORDER_D_FROM <
DateTime.Now
) &&
(po.PORDER_D_TO == null || po.PORDER_D_TO > DateTime.Now.Date) &&
(po.PORDER_B_NIGHT == 1 || bNightmode == false) &&
lOrdertypes.Contains(po.PORDER_I_TYPE)
select po;
if (query.Count() == 0) return "NOT_FOUND"; // order not found!
Why and where should i use a integer???!!!
regards
Richard.