Devart Forums

slmnn

We are using the earlier example to read DateTimeOffset from Oracle:

Pinturiccio wrote: ↑Mon 06 May 2019 14:09 You can read datetime offset. Let's consider the following example:
Code: Select all
...
        OracleTimeStamp offset = (OracleTimeStamp)oraObj.GetOracleValue("offset");
        Console.WriteLine(offset.TimeZoneOffset);
...

After updating DevArt dotConnect for Oracle to 9.13.1098 reading offset in TZR format seems to be broken. The timestamp in the DB is

Code: Select all

03.12.2020 11:02:08,598895000 EUROPE/HELSINKI

but we are reading

Code: Select all

3.12.2020 9:02:08 +02:00

The same issue persists with the latest 9.13.1127.

With version 9.12.1064 the timestamp is read correctly. Also reading timestamps with offset in TZH:TZM seems to be working fine.

slmnn

We are experiencing the same issue with the latest dotConnect for Oracle (9.11). Currently we are holding back from updating version 9.9.887 as it seems to work. Our Fluent API configuration is:

Code: Select all

        
            builder.ToTable("TABLE_NAME")
                .HasKey(e => e.Id);

            builder.HasIndex(e => new { e.Id })
                .IsUnique();

            builder.Property(e => e.Id)
                .ValueGeneratedOnAdd();
                
            ...

Where Id property is a GUID.

So in our case, something is broken in dotConnect for Oracle after 9.9.887.

Devart Forums

Search found 2 matches

Re: How to read DateTimeOffset from OracleObject

Re: EF Core 3.1 - Guid primary key not generated