Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 18
- Joined: Sat 07 Jul 2018 14:20
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?).
- Site Admin
- Posts: 9040
- Joined: Thu 14 Aug 2008 12:44
The feature is not supported.
As a workaround, please iterate through the collection and extend the LINQ query with the conditions AND, OR, ==.