Is there a way to use Ormlite to perform a
SELECT on a table (in Oracle, in this case) where the filter is a subset of the columns of an
IEnumerable. I’d be interested if there were a way to execute a query that returns the same results as the following hand-rolled SQL:
SELECT * FROM TEST WHERE (COL_1, COL_2, COL_3, COL_4, COL_5) IN ( ('1', '0', '234', '3'), ('2', '0', '098', '16.1166666666667', '3') )
Where, however, the
IEnumerable to be passed in contains more than those 5 fields.