In-condition with parameterized expression list

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Thomasdc
Posts: 18
Joined: Sat 07 Jul 2018 14:20

In-condition with parameterized expression list

Post by Thomasdc » 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):

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
Site Admin
Posts: 9046
Joined: Thu 14 Aug 2008 12:44

Re: In-condition with parameterized expression list

Post by Shalex » 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, ==.

Post Reply