Devart Forums

Posted: **Tue 09 Oct 2018 08:00**

I am using .Net Core 2.1 with Devart.Data.Oracle 9.6.597.

I Have following Entity and Configuration

  public class GuaranteeLetter : BaseEntity{
          public string XmlData { get; set; }  
  }

Code: Select all

     modelBuilder.Property<string>(x => x.XmlData).HasColumnType("XMLTYPE").ValueGeneratedNever();

On Oracle I have:

CREATE TABLE GUARANTEE_LETTER
(
XMLDATA XMLTYPE;
);

I have XMLTYPE column in database. When I try to insert data using Entity Framework Core 2.1 I am getting the error below.

ORA-00932: inconsistent datatypes: expected - got NCLOB

I Could not find solution or workaround for this issue.

I need urgent help.

Thanks

Posted: **Thu 11 Oct 2018 19:51**

Thank you for your report. We have reproduced the issue and will notify you when it is fixed.

Posted: **Thu 25 Oct 2018 16:49**

The bug with inserting data into XMLTYPE column via EF Core is fixed: viewtopic.php?f=1&t=37913.

Devart Forums

Inconsistent DataType on XMLTYPE column

Inconsistent DataType on XMLTYPE column

Re: Inconsistent DataType on XMLTYPE column

Re: Inconsistent DataType on XMLTYPE column