The issue in summary:
We have a table with a RAW(16) identifier. PARAMETERID NOT NULL RAW(16 BYTE)
An EF Code-First app that maps this table to a Guid property.
An entity that maps to property/table. public Guid PARAMETERID { get; set; }
Its EF configuration.
public HRHubParameterDBEntityConfiguration() {
ToTable("PARAMETERS");
HasKey(a => a.PARAMETERID);
Property(a => a.PARAMETERID)
.HasColumnName("PARAMETERID");
Property(a => a.NAME)
.HasColumnName("NAME");
}
public DbSet<HRHubParameterDBEntity> Parameters { get; set; }
On actual Oracle DB we have the following value on its id
25B9118570E3EB4BB41E45ED70CECD81
and the following name TEST
When we read with ODP.NET 19.12.0 we get the following Guid value:
8511b925-e370-4beb-b41e-45ed70cecd81
When we read with ODP.NET 21.3.0 we get the following Guid value:
25b91185-70e3-eb4b-b41e-45ed70cecd81
As you see there is a reversal in the first three parts of the read value, the last two parts remain the same.
It seems there is a SERIOUS issue when reading RAW(16)/GUID values from database with the latest release.
Please advise.