Devart Forums

Posted: **Wed 27 Nov 2019 07:55**

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

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?).

Posted: **Thu 28 Nov 2019 16:09**

The feature is not supported.

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

In-condition with parameterized expression list