Oracle Problem upgrading to NET10/EF10 with queries using contains.

Oracle Problem upgrading to NET10/EF10 with queries using contains.

Hi,

after upgrading to the latest version simple queries with contains no longer work for me.

I'm using an
- Oracle 19c database patched to 19.26.0.0 and
- EF 10.0.4
- Devart.Data.Oracle.EFCore 11.1.35.10 and 11.1.33.10 (both verified not working for me)

For a query like context.Underlyings.Where(w => isins.contains(w.Isin)).ToList() I get

System.AggregateException: One or more errors occurred. (Expression '@isins' in the SQL tree does not have a type mapping assigned.) ---> System.InvalidOperationException: Expression '@isins' in the SQL tree does not have a type mapping assigned.

I have verified that when i switch back to 11.1.35.9 and 11.1.33.9 and EF 9.0.14, it works as expected using the NET10 upgraded solution, so it seems EF10 specific. I tried all 3 parameter settings that are available in the UseOracle extension method (see sample).

I have attached a minimalistic project that reproduces the error for me connecting to a oracle 19c (19.26.0.0) database. Any ideas what I'm doing wrong or is there a bug, which seems unlikely to me given the basic nature of the query.

Best,
Martin