Write IN condition with multiple columns in Linq
Posted: Mon 14 Sep 2020 13:38
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?
The array of ( ('John', 'Doe'), ('Jane', 'Doe') ) should of course be a parameter.
Thank you for your help.
Code: Select all
SELECT *
FROM customer c
WHERE (c.firstname, c.lastname) IN ( ('John', 'Doe'), ('Jane', 'Doe') )
Thank you for your help.