bjan
bjan

Reputation: 2030

calculated value in where clause

I am working with Entity Spaces and need to run following query

select * from MyTable WHERE (Age * 10) IN (50, 60, 70)

ES version is

query.Where((query.Age * 10).In(AgesList));

This generates following invalid query (Age * 10 is missing)

select * from MyTable WHERE IN (50, 60, 70)

Any solution to produce desired query?

Upvotes: 1

Views: 53

Answers (0)

Related Questions