Problem with mapping nullable column (Oracle Provider)

[dzambo2302]

I'm starting with Database First mapping (Devart Oracle Provider 9.6.584.0 - licensed) and I'm facing to interesting error. Edml model is generated correctly, properties which should be nullable are set to nullable on Classes part and also on Store part, but Desinger code contains those properties as not null types and that causes runtime errors when I'm trying to execute a query.

What am I doing wrong?

Oracle table example:

Code: Select all

create table ORDERS
(
  ID                        NUMBER not null,
  ORG_ID       NUMBER(10) not null,
  ORDER_NUMBER              NUMBER(10) not null,
  PARTNERS_ID            NUMBER(10),
  TIME_PASS_PLANNED         INTERVAL DAY(2) TO SECOND(0),
  ROUTES_ID          NUMBER(10)
)

Part of Desinger code as an example:

Code: Select all

	[EdmScalarPropertyAttribute()]
        [DataMemberAttribute()]
        public virtual global::System.Decimal PARTNERS_ID
        {
            get
            {
                global::System.Decimal value = _PARTNERS_ID;
                OnGetPARTNERS_ID(ref value);
                return value;
            }
            set
            {
                if (_PARTNERS_ID != value)
                {
                  OnPARTNERS_IDChanging(ref value);
                  ReportPropertyChanging("PARTNERS_ID");
                  _PARTNERS_ID = StructuralObject.SetValidValue(value);
                  ReportPropertyChanged("PARTNERS_ID");
                  OnPARTNERS_IDChanged();
              }
            }
        }
        private global::System.Decimal _PARTNERS_ID;
        partial void OnGetPARTNERS_ID(ref global::System.Decimal value);
        partial void OnPARTNERS_IDChanging(ref global::System.Decimal value);
        partial void OnPARTNERS_IDChanged();
        
        [EdmScalarPropertyAttribute()]
        [DataMemberAttribute()]
        public virtual global::System.TimeSpan TIME_PASS_PLANNED
        {
            get
            {
                global::System.TimeSpan value = _TIME_PASS_PLANNED;
                OnGetTIME_PASS_PLANNED(ref value);
                return value;
            }
            set
            {
                if (_TIME_PASS_PLANNED != value)
                {
                  OnTIME_PASS_PLANNEDChanging(ref value);
                  ReportPropertyChanging("TIME_PASS_PLANNED");
                  _TIME_PASS_PLANNED = StructuralObject.SetValidValue(value);
                  ReportPropertyChanged("TIME_PASS_PLANNED");
                  OnTIME_PASS_PLANNEDChanged();
              }
            }
        }
        private global::System.TimeSpan _TIME_PASS_PLANNED;
        partial void OnGetTIME_PASS_PLANNED(ref global::System.TimeSpan value);
        partial void OnTIME_PASS_PLANNEDChanging(ref global::System.TimeSpan value);
        partial void OnTIME_PASS_PLANNEDChanged();

[Pinturiccio]

This is a known issue. We have already fixed it.
The bug with code generation for nullable properties for EF1/EF4/EF5/EF6 is fixed

We will post here when the corresponding build of dotConnect for Oracle is available for download.

[dzambo2302]

Thank you for a quick response.
Is there any ETA on the new build?

[Pinturiccio]

We are planning to release a new public build of dotConnect for Oracle at the end of the next week. You can downgrade to a previous public build. Or if you are interested, we can send you an internal build with the fix. Please send us the license number or email, for which dotConnect for Oracle were purchased.

[Pinturiccio]

New build of Entity Developer 6.3.582 is available for download!
It can be downloaded from https://www.devart.com/entitydeveloper/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37707

[Pinturiccio]

New build of dotConnect for Oracle 9.6.597 is available for download.
It can be downloaded from https://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
We have also updated our NuGet package: https://www.nuget.org/packages/Devart.D ... le.EFCore/
For more information, please refer to viewtopic.php?t=37715