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