DefaultValue for Property
Posted: Fri 11 Apr 2014 08:25
Migrating from dotConnect for Oracle v7 and Entity FrameWork 4.0 to dotConnect for Oracle v8.3.135.6 and Entity Framework 6.1. Still using EntityObject template.
Here's an example of an existing table.
Gives me this:
And this:
So when I run the code I get:
And the exception: {"ORA-12899: value too large for column \"PL\".\"SYSTEMPARAMETRAR\".\"SKP_TID\" (actual: 29, maximum: 8)"}
I get the text "to_char(sysdate, 'HH24:MI:SS')" instead of the result from the function.
This worked in EF4.0, have I missed something in my update?
Regards,
Patrik
Here's an example of an existing table.
Code: Select all
CREATE
TABLE "PL"."SYSTEMPARAMETRAR"
(
"GRUPP" CHAR(16 BYTE) DEFAULT NULL,
"LINJE" CHAR(16 BYTE) DEFAULT NULL,
"PARAMETER" CHAR(20 BYTE) DEFAULT NULL NOT NULL ENABLE,
"PARAMETER_DATA" CHAR(72 BYTE) DEFAULT ' ',
"TYP" CHAR(1 BYTE),
"MAX_STORLEK" NUMBER(*,0) DEFAULT 0,
"MIN_STORLEK" NUMBER(*,0) DEFAULT 0,
"KOMMENTAR" CHAR(50 BYTE) DEFAULT ' ',
"SKP_DATUM" DATE DEFAULT sysdate,
"SKP_TID" CHAR(8 BYTE) DEFAULT TO_CHAR(sysdate,'HH24:MI:SS'),
"UPD_DATUM" DATE DEFAULT sysdate,
"UPD_TID" CHAR(8 BYTE) DEFAULT TO_CHAR(sysdate,'HH24:MI:SS'),
"ANTAL_UPPDATERINGAR" NUMBER(*,0) DEFAULT 0,
CONSTRAINT "SYSTEMPARAMETRAR_PRIM_KEY" PRIMARY KEY ("GRUPP", "LINJE", "PARAMETER") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "PLTSIDX" ENABLE,
CHECK ( max_storlek >= 0 ) ENABLE,
CHECK ( min_storlek >= 0 ) ENABLE,
CHECK ( antal_uppdateringar >= 0 ) ENABLE
)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE
(
INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "PLTS1" ;
Code: Select all
/// <summary>
/// There are no comments for PaperLine.Main.Common.DomainModel.MainModel.SYSTEMPARAMETRAR in the schema.
/// </summary>
/// <KeyProperties>
/// GRUPP
/// LINJE
/// PARAMETER
/// </KeyProperties>
[EdmEntityTypeAttribute(NamespaceName="PaperLine.Main.Common.DomainModel.MainModel", Name="SYSTEMPARAMETRAR")]
[Serializable()]
[DataContractAttribute(IsReference=true)]
public partial class SYSTEMPARAMETRAR : EntityObject {
#region Factory Method
/// <summary>
/// Create a new SYSTEMPARAMETRAR object.
/// </summary>
/// <param name="gRUPP">Initial value of GRUPP.</param>
/// <param name="lINJE">Initial value of LINJE.</param>
/// <param name="pARAMETER">Initial value of PARAMETER.</param>
public static SYSTEMPARAMETRAR CreateSYSTEMPARAMETRAR(string gRUPP, string lINJE, string pARAMETER)
{
SYSTEMPARAMETRAR sYSTEMPARAMETRAR = new SYSTEMPARAMETRAR();
sYSTEMPARAMETRAR.GRUPP = gRUPP;
sYSTEMPARAMETRAR.LINJE = lINJE;
sYSTEMPARAMETRAR.PARAMETER = pARAMETER;
return sYSTEMPARAMETRAR;
}
#endregion
#region Properties
/// <summary>
/// There are no comments for GRUPP in the schema.
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public string GRUPP
{
get
{
string value = _GRUPP;
OnGetGRUPP(ref value);
return value;
}
set
{
if (_GRUPP != value)
{
OnGRUPPChanging(ref value);
ReportPropertyChanging("GRUPP");
_GRUPP = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("GRUPP");
OnGRUPPChanged();
}
}
}
private string _GRUPP;
partial void OnGetGRUPP(ref string value);
partial void OnGRUPPChanging(ref string value);
partial void OnGRUPPChanged();
/// <summary>
/// There are no comments for LINJE in the schema.
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public string LINJE
{
get
{
string value = _LINJE;
OnGetLINJE(ref value);
return value;
}
set
{
if (_LINJE != value)
{
OnLINJEChanging(ref value);
ReportPropertyChanging("LINJE");
_LINJE = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("LINJE");
OnLINJEChanged();
}
}
}
private string _LINJE;
partial void OnGetLINJE(ref string value);
partial void OnLINJEChanging(ref string value);
partial void OnLINJEChanged();
/// <summary>
/// There are no comments for PARAMETER in the schema.
/// </summary>
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)]
[DataMemberAttribute()]
public string PARAMETER
{
get
{
string value = _PARAMETER;
OnGetPARAMETER(ref value);
return value;
}
set
{
if (_PARAMETER != value)
{
OnPARAMETERChanging(ref value);
ReportPropertyChanging("PARAMETER");
_PARAMETER = StructuralObject.SetValidValue(value, false);
ReportPropertyChanged("PARAMETER");
OnPARAMETERChanged();
}
}
}
private string _PARAMETER;
partial void OnGetPARAMETER(ref string value);
partial void OnPARAMETERChanging(ref string value);
partial void OnPARAMETERChanged();
/// <summary>
/// There are no comments for PARAMETER_DATA in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public string PARAMETER_DATA
{
get
{
string value = _PARAMETER_DATA;
OnGetPARAMETER_DATA(ref value);
return value;
}
set
{
if (_PARAMETER_DATA != value)
{
OnPARAMETER_DATAChanging(ref value);
ReportPropertyChanging("PARAMETER_DATA");
_PARAMETER_DATA = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("PARAMETER_DATA");
OnPARAMETER_DATAChanged();
}
}
}
private string _PARAMETER_DATA = @" ";
partial void OnGetPARAMETER_DATA(ref string value);
partial void OnPARAMETER_DATAChanging(ref string value);
partial void OnPARAMETER_DATAChanged();
/// <summary>
/// There are no comments for TYP in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public string TYP
{
get
{
string value = _TYP;
OnGetTYP(ref value);
return value;
}
set
{
if (_TYP != value)
{
OnTYPChanging(ref value);
ReportPropertyChanging("TYP");
_TYP = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("TYP");
OnTYPChanged();
}
}
}
private string _TYP;
partial void OnGetTYP(ref string value);
partial void OnTYPChanging(ref string value);
partial void OnTYPChanged();
/// <summary>
/// There are no comments for MAX_STORLEK in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public global::System.Nullable<decimal> MAX_STORLEK
{
get
{
global::System.Nullable<decimal> value = _MAX_STORLEK;
OnGetMAX_STORLEK(ref value);
return value;
}
set
{
if (_MAX_STORLEK != value)
{
OnMAX_STORLEKChanging(ref value);
ReportPropertyChanging("MAX_STORLEK");
_MAX_STORLEK = StructuralObject.SetValidValue(value);
ReportPropertyChanged("MAX_STORLEK");
OnMAX_STORLEKChanged();
}
}
}
private global::System.Nullable<decimal> _MAX_STORLEK = 0m;
partial void OnGetMAX_STORLEK(ref global::System.Nullable<decimal> value);
partial void OnMAX_STORLEKChanging(ref global::System.Nullable<decimal> value);
partial void OnMAX_STORLEKChanged();
/// <summary>
/// There are no comments for MIN_STORLEK in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public global::System.Nullable<decimal> MIN_STORLEK
{
get
{
global::System.Nullable<decimal> value = _MIN_STORLEK;
OnGetMIN_STORLEK(ref value);
return value;
}
set
{
if (_MIN_STORLEK != value)
{
OnMIN_STORLEKChanging(ref value);
ReportPropertyChanging("MIN_STORLEK");
_MIN_STORLEK = StructuralObject.SetValidValue(value);
ReportPropertyChanged("MIN_STORLEK");
OnMIN_STORLEKChanged();
}
}
}
private global::System.Nullable<decimal> _MIN_STORLEK = 0m;
partial void OnGetMIN_STORLEK(ref global::System.Nullable<decimal> value);
partial void OnMIN_STORLEKChanging(ref global::System.Nullable<decimal> value);
partial void OnMIN_STORLEKChanged();
/// <summary>
/// There are no comments for KOMMENTAR in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public string KOMMENTAR
{
get
{
string value = _KOMMENTAR;
OnGetKOMMENTAR(ref value);
return value;
}
set
{
if (_KOMMENTAR != value)
{
OnKOMMENTARChanging(ref value);
ReportPropertyChanging("KOMMENTAR");
_KOMMENTAR = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("KOMMENTAR");
OnKOMMENTARChanged();
}
}
}
private string _KOMMENTAR = @" ";
partial void OnGetKOMMENTAR(ref string value);
partial void OnKOMMENTARChanging(ref string value);
partial void OnKOMMENTARChanged();
/// <summary>
/// There are no comments for SKP_DATUM in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public global::System.Nullable<System.DateTime> SKP_DATUM
{
get
{
global::System.Nullable<System.DateTime> value = _SKP_DATUM;
OnGetSKP_DATUM(ref value);
return value;
}
set
{
if (_SKP_DATUM != value)
{
OnSKP_DATUMChanging(ref value);
ReportPropertyChanging("SKP_DATUM");
_SKP_DATUM = StructuralObject.SetValidValue(value);
ReportPropertyChanged("SKP_DATUM");
OnSKP_DATUMChanged();
}
}
}
private global::System.Nullable<System.DateTime> _SKP_DATUM = DateTime.Now;
partial void OnGetSKP_DATUM(ref global::System.Nullable<System.DateTime> value);
partial void OnSKP_DATUMChanging(ref global::System.Nullable<System.DateTime> value);
partial void OnSKP_DATUMChanged();
/// <summary>
/// There are no comments for SKP_TID in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public string SKP_TID
{
get
{
string value = _SKP_TID;
OnGetSKP_TID(ref value);
return value;
}
set
{
if (_SKP_TID != value)
{
OnSKP_TIDChanging(ref value);
ReportPropertyChanging("SKP_TID");
_SKP_TID = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("SKP_TID");
OnSKP_TIDChanged();
}
}
}
private string _SKP_TID = @"to_char(sysdate,'HH24:MI:SS')";
partial void OnGetSKP_TID(ref string value);
partial void OnSKP_TIDChanging(ref string value);
partial void OnSKP_TIDChanged();
/// <summary>
/// There are no comments for UPD_DATUM in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public global::System.Nullable<System.DateTime> UPD_DATUM
{
get
{
global::System.Nullable<System.DateTime> value = _UPD_DATUM;
OnGetUPD_DATUM(ref value);
return value;
}
set
{
if (_UPD_DATUM != value)
{
OnUPD_DATUMChanging(ref value);
ReportPropertyChanging("UPD_DATUM");
_UPD_DATUM = StructuralObject.SetValidValue(value);
ReportPropertyChanged("UPD_DATUM");
OnUPD_DATUMChanged();
}
}
}
private global::System.Nullable<System.DateTime> _UPD_DATUM = DateTime.Now;
partial void OnGetUPD_DATUM(ref global::System.Nullable<System.DateTime> value);
partial void OnUPD_DATUMChanging(ref global::System.Nullable<System.DateTime> value);
partial void OnUPD_DATUMChanged();
/// <summary>
/// There are no comments for UPD_TID in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public string UPD_TID
{
get
{
string value = _UPD_TID;
OnGetUPD_TID(ref value);
return value;
}
set
{
if (_UPD_TID != value)
{
OnUPD_TIDChanging(ref value);
ReportPropertyChanging("UPD_TID");
_UPD_TID = StructuralObject.SetValidValue(value, true);
ReportPropertyChanged("UPD_TID");
OnUPD_TIDChanged();
}
}
}
private string _UPD_TID = @"to_char(sysdate,'HH24:MI:SS')";
partial void OnGetUPD_TID(ref string value);
partial void OnUPD_TIDChanging(ref string value);
partial void OnUPD_TIDChanged();
/// <summary>
/// There are no comments for ANTAL_UPPDATERINGAR in the schema.
/// </summary>
[EdmScalarPropertyAttribute()]
[DataMemberAttribute()]
public global::System.Nullable<decimal> ANTAL_UPPDATERINGAR
{
get
{
global::System.Nullable<decimal> value = _ANTAL_UPPDATERINGAR;
OnGetANTAL_UPPDATERINGAR(ref value);
return value;
}
set
{
if (_ANTAL_UPPDATERINGAR != value)
{
OnANTAL_UPPDATERINGARChanging(ref value);
ReportPropertyChanging("ANTAL_UPPDATERINGAR");
_ANTAL_UPPDATERINGAR = StructuralObject.SetValidValue(value);
ReportPropertyChanged("ANTAL_UPPDATERINGAR");
OnANTAL_UPPDATERINGARChanged();
}
}
}
private global::System.Nullable<decimal> _ANTAL_UPPDATERINGAR = 0m;
partial void OnGetANTAL_UPPDATERINGAR(ref global::System.Nullable<decimal> value);
partial void OnANTAL_UPPDATERINGARChanging(ref global::System.Nullable<decimal> value);
partial void OnANTAL_UPPDATERINGARChanged();
#endregion
}
Code: Select all
<EntityType Name="SYSTEMPARAMETRAR">
<Key>
<PropertyRef Name="GRUPP" />
<PropertyRef Name="LINJE" />
<PropertyRef Name="PARAMETER" />
</Key>
<Property Name="GRUPP" Type="CHAR" Nullable="false" MaxLength="16" />
<Property Name="LINJE" Type="CHAR" Nullable="false" MaxLength="16" />
<Property Name="PARAMETER" Type="CHAR" Nullable="false" MaxLength="20" />
<Property Name="PARAMETER_DATA" Type="CHAR" MaxLength="72" devart:DefaultValue="' '" DefaultValue=" " />
<Property Name="TYP" Type="CHAR" MaxLength="1" />
<Property Name="MAX_STORLEK" Type="decimal" Scale="0" DefaultValue="0" />
<Property Name="MIN_STORLEK" Type="decimal" Scale="0" DefaultValue="0" />
<Property Name="KOMMENTAR" Type="CHAR" MaxLength="50" devart:DefaultValue="' '" DefaultValue=" " />
<Property Name="SKP_DATUM" Type="DATE" devart:DefaultValue="sysdate" />
<Property Name="SKP_TID" Type="CHAR" MaxLength="8" DefaultValue="to_char(sysdate,'HH24:MI:SS')" />
<Property Name="UPD_DATUM" Type="DATE" devart:DefaultValue="sysdate" />
<Property Name="UPD_TID" Type="CHAR" MaxLength="8" DefaultValue="to_char(sysdate,'HH24:MI:SS')" />
<Property Name="ANTAL_UPPDATERINGAR" Type="decimal" Scale="0" DefaultValue="0" />
</EntityType>
And the exception: {"ORA-12899: value too large for column \"PL\".\"SYSTEMPARAMETRAR\".\"SKP_TID\" (actual: 29, maximum: 8)"}
I get the text "to_char(sysdate, 'HH24:MI:SS')" instead of the result from the function.
This worked in EF4.0, have I missed something in my update?
Regards,
Patrik