Difficulty creating proper RavenDB query -
i trying implement logic below in ravendb query, receive
system.notsupportedexception: not understand expression
related scores.any
expression. understand why is, i'm having hard time coming working option.
public iravenqueryable<person> apply(iravenqueryable<person> query) { var scores = new list<string>(); if (_a) scores.add("a"); if (_b) scores.add("b"); if (_c) scores.add("c"); if (_u) { scores.add(""); scores.add(" "); scores.add("\t"); scores.add(null); } return p in query scores.any(score => score == p.score) select p; }
the trick ravendb linq provider isn't operating on list scores.any() makes 0 sense -- compiles can see dies @ runtime.
the trick reverse field bit , ask if p.score in array of scores if recall correctly.
Comments
Post a Comment