2 Ответы Последний ответ: 18.10.2019 23:29, автор: Alex Keh - Product Manager-Oracle

    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