Entity model for Self- Reference table

[djuj]

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.

[AndreyR]

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?