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?