dotConnect for Oracle version 5.0.20
The relation ship between to tables cannot be processed. I have two tables, which have parent-child relation ship. After generate code using Entity Developer, running website, the Object reference not set to an instance of an object exception throw.
Code to create database:
Code: Select all
DROP SEQUENCE v2_seq_File;
DROP SEQUENCE v2_seq_Message;
CREATE TABLE v2_data_File(
File_Id NUMBER(10, 0) NOT NULL,
Message_Id NUMBER(38, 0) NOT NULL,
File_Name NVARCHAR2(128) NOT NULL,
Body LONG RAW NOT NULL,
CONSTRAINT PK113 PRIMARY KEY (File_Id)
)
;
CREATE TABLE v2_data_Message(
Message_Id NUMBER(10, 0) NOT NULL,
Parent_Id NUMBER(10, 0),
From_Dealer VARCHAR2(30),
To_Dealer VARCHAR2(30),
Body NVARCHAR2(512) NOT NULL,
Created_Date TIMESTAMP(6) NOT NULL,
Created_By NVARCHAR2(256) NOT NULL,
Flag CHAR(1) NOT NULL,
CONSTRAINT v2_PK01 PRIMARY KEY (Message_Id)
)
;
ALTER TABLE v2_data_File ADD CONSTRAINT Refv2_data_Message189
FOREIGN KEY (Message_Id)
REFERENCES v2_data_Message(Message_Id)
;
ALTER TABLE v2_data_Message ADD CONSTRAINT Refv2_data_Message180
FOREIGN KEY (Parent_Id)
REFERENCES v2_data_Message(Message_Id)
;
CREATE SEQUENCE v2_seq_File MINVALUE 1 MAXVALUE
999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20;
CREATE OR REPLACE TRIGGER v2_data_File_U_PK BEFORE INSERT ON v2_data_File
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
SELECT v2_seq_File.NEXTVAL INTO :NEW.File_Id FROM DUAL;
END;
/
CREATE SEQUENCE v2_seq_Message MINVALUE 1 MAXVALUE
999999999999999999999999999 START WITH 1 INCREMENT BY 1 CACHE 20;
CREATE OR REPLACE TRIGGER v2_data_Message_U_PK BEFORE INSERT ON v2_data_Message
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
SELECT v2_seq_Message.NEXTVAL INTO :NEW.Message_Id FROM DUAL;
END;
/
Code: Select all
[NullReferenceException: Object reference not set to an instance of an object.]
Devart.Data.Linq.r.a(Object& A_0, Object A_1, MetaDataMember A_2) +484
Devart.Data.Linq.r.a(MetaType A_0, n A_1, ModifiedMemberInfo[] A_2) +2291
Devart.Data.Linq.t.a(h A_0, Object A_1, ModifiedMemberInfo[] A_2) +465
Devart.Data.Linq.i.a(e A_0) +342
Devart.Data.Linq.i.d() +44
Devart.Data.Linq.DataContext.SubmitChanges() +73
_Default.Button1_Click(Object sender, EventArgs e) in d:\Working\Temp\TestDevart\Default.aspx.cs:23
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
PLEASE check and fix soon.