I have this code:
The generated sql code of lightspeed is:
The where clause is not what I want and the results is also not what I want.
To get a valid result, I must do:
The generated sql is:
Could you please explain to me why I must do the second solution? Is it a bug in the first case?
Thank you very much.
This will be a translation issue. The first statement infers a predicate where as the second one actually defines one when it comes to how these are represented in the LINQ expression trees. I will have a look at this, it sounds like we will just need to add some additional detection and translation for this particular case.