EntityFrameworkCore - querying NCLOB — oracle-tech

    Forum Stats

  • 3,715,645 Users
  • 2,242,819 Discussions


Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

EntityFrameworkCore - querying NCLOB

4085346 Member Posts: 4
edited October 2019 in ODP.NET

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


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?



Sign In or Register to comment.