Thank you for your input.
Indeed such limitations are imposed by the relational database servers. Regarding the bahaviour of Telerik Data Access in such situations, let me assure you that it is capable of executing bulk select statements entirely on the server. In this documentation article
you can find the details about how the limitations are worked around and what queries are generated according to the scenario circumstances. Additionally, here
is a blogpost that provides an example of the Contains() usage.
I hope this helps. In case you have additional questions, do not hesitate to get back to us.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map