In-condition with parameterized expression list

[Thomasdc]

In Oracle it's possible to write queries like this one (see https://docs.oracle.com/cd/B19306_01/se ... m#i1033664):

Code: Select all

SELECT * FROM employees 
WHERE (first_name, last_name, email) IN 
  (('Guy', 'Himuro', 'GHIMURO'),('Karen', 'Colmenares', 'KCOLMENA')) 

Is it possible to programmatically write a similar query with the expression list being a parameter (for example a list of tuples?).

[Shalex]

The feature is not supported.

As a workaround, please iterate through the collection and extend the LINQ query with the conditions AND, OR, ==.