Write IN condition with multiple columns in Linq

[rits-development]

I was wondering if there is a way to leverage the feature of the Oracle IN operator which allows for querying multiple columns at once. For example, can I write the following query using Linq and is there a way which DevArt can properly translate it to this SQL?

Code: Select all

SELECT *
FROM customer c
WHERE (c.firstname, c.lastname) IN ( ('John', 'Doe'), ('Jane', 'Doe') )

The array of ( ('John', 'Doe'), ('Jane', 'Doe') ) should of course be a parameter.

Thank you for your help.

[Shalex]

This functionality is not supported by LINQ queries.