EntityFrameworkCore - querying NCLOB

4085346

Hello, I've seen this documentation about annotating a string property with [MaxLength(65536)] to create an NCLOB column:

https://docs.oracle.com/en/database/oracle/oracle-data-access-components/19.3/odpnt/EFCoreLargeCharacter.html#GUID-AE805…

However, the issue I have is that I cannot query on this property. Comparing to the Devart driver, I can see that that uses a special compare function when it knows the property is mapped to an nclob column. However, with your Oracle driver, even with that annotation, the query does a straight string comparison, which is not allowed and leads to the error "ORA-00932: inconsistent datatypes: expected - got NCLOB"

Is this expected behaviour, or is this a known bug, and is there a way to fix it?

Thanks

4085346

Alternative question: how can I raise a bug?

Alex Keh-Oracle

This is not a known bug. You can open a service request with Oracle Support with a test case and we'll investigate and provide a fix if it's a problem in the Oracle EF Core code.

https://support.oracle.com