Query bit logic

Hello to all,

Can I make something like this:

MyCriteria.Add( (Linq['MyProp'] and 4) = 4); // MyProp is Integer

If not, is there another solution?

Thomas

Hi Thomas,

Unfortunately no, it's not possible.
I think one workaround is that you create specific SQL functions, like BitwiseAnd('MyProp', 4).
Or, maybe even better, just use SQL expression and do it at low SQL level.

Ok, in this case I only have 7 states (4 bits) and I can do it with the "IN" operator.
I will take that into account when designing the database. Rarely happens to me.

1 Like

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.