Devart Forums

Posted: **Thu 29 Oct 2009 21:48**

I am trying to create entity model based on self-referencing table I tried something similar to what is mentioned in the following site

http://thedatafarm.com/blog/data-access ... tionships/

but with devart entity developer I am unable to achieve similar result.
The only difference is that I dont have RI in Database, however I specified them when adding the association.

Posted: **Mon 02 Nov 2009 16:11**

I have tried a simple example using the latest Entity Developer Beta with script like the following and succeeded.

Code: Select all

create table selfparent (id int primary key, name varchar2(20));
create table selflink(fromid int, toid int,
foreign key (fromid) references selfparent(id),
foreign key (toid) references selfparent(id),
primary key (fromid, toid))

Could you please post the script of the tables you get the error on?

Devart Forums

Entity model for Self- Reference table

Entity model for Self- Reference table