How can I configure Entity Framework Core to handle nchar(N) fields retrieved from Oracle?

Asked Apr 23 '21 at 15:54

Active Apr 23 '21 at 16:19

Viewed 126 times

We have done a migration from Microsoft SQL Server to Oracle. We use Entity Framework Core code-first.

We have some columns in the databases of type nchar(n), and as you already know, if we insert 'ismail' into a NCHAR(10) column, it will be inserted as 'ismail '.

When we point the connection string to SQL Server and we search for a record by its Id, it's found and retrieved and works fine. But when we connect to Oracle, it returns null because I need to add spaces to the Id.

I tried this in my entity model. But this didn't worked.

entity.Property(e => e.Name)
      .HasConversion(new ValueConverter<string, string>(v => v.TrimEnd(), v => 
       v.TrimEnd()));

edited Apr 23 '21 at 16:19

asked Apr 23 '21 at 15:54

Ismail Fedaoui

So why aren't you using `NVARCHAR2(n)` datatypes in Oracle, to avoid this hassle? – marc_s Apr 23 '21 at 16:47
@marc_s because it will impact the production's code – Ismail Fedaoui Apr 23 '21 at 16:52

How can I configure Entity Framework Core to handle nchar(N) fields retrieved from Oracle?

0 Answers0