Page 1 of 1

DeleteRule="CASCADE" doesn't appear in datacontext classes

Posted: Tue 18 Aug 2009 13:56
by iOgre
Hello, I'v used following sql to create my database:

CREATE TABLE street
(
... my fields here ...
CONSTRAINT pk_street PRIMARY KEY (id),
CONSTRAINT fk_street_reference_town FOREIGN KEY (id_town)
REFERENCES town (id) MATCH SIMPLE
ON UPDATE RESTRICT ON DELETE CASCADE,
CONSTRAINT fk_street_street_types FOREIGN KEY (id_type)
REFERENCES street_types (id) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE SET NULL,
CONSTRAINT street_fk FOREIGN KEY (id_region)
REFERENCES region (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE SET NULL
)
WITH (OIDS=FALSE);
ALTER TABLE street OWNER TO postgres;

But, when I'm trying to generate DataContext classes using EntityDeveloper application, there is no DeleteRule="CASCADE" options in
[Association ... ] attribute.
Even if I'm trying to set DeleteRule="Cascase" in lqml file, this option does not appear.
What can (or must) I do?

Posted: Wed 19 Aug 2009 09:11
by AndreyR
We will investigate the possibility to add this functionality.
I will let you know about the results of our investigation.

Posted: Fri 21 Aug 2009 13:39
by iOgre
Thank you!

Posted: Fri 23 Oct 2009 11:12
by AndreyR
We have fixed the problem. The fix will be available in the new Beta build of Entity Developer.