Entity model for Self- Reference table

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
Posts: 4
Joined: Thu 25 Jun 2009 18:45

Entity model for Self- Reference table

Post by djuj » 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.

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » 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?

Post Reply