This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I'm using Lightspeed 5.0.2302 to access sql server database. I have a data model, where documents have metadata (essentially key-value -pairs) associated to them. I'm trying to find all the documents, that have N known metadata, and do not have M known metadata keys. Here's the query I'm constructing:
Here is the generated sql:
If I have understood correctly, the ANDs separating Name/Value comparisons inside the EXISTS should be ORs. Is this a bug, or have I misunderstood how chained Any() is supposed to work? If I define variable docs with .AsEnumerable(), then the query works as it should. |
|