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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
iOgre
Posts: 10
Joined: Tue 14 Apr 2009 11:46

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

Post by iOgre » Tue 18 Aug 2009 13:56

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?

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

Post by AndreyR » Wed 19 Aug 2009 09:11

We will investigate the possibility to add this functionality.
I will let you know about the results of our investigation.

iOgre
Posts: 10
Joined: Tue 14 Apr 2009 11:46

Post by iOgre » Fri 21 Aug 2009 13:39

Thank you!

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

Post by AndreyR » Fri 23 Oct 2009 11:12

We have fixed the problem. The fix will be available in the new Beta build of Entity Developer.

Post Reply