The Action Restrict on <tablename> not recognized.

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
kevinrowe
Posts: 1
Joined: Thu 14 Jan 2010 11:51
Location: sittingbourne,kent,uk

The Action Restrict on <tablename> not recognized.

Post by kevinrowe » Thu 14 Jan 2010 12:10

building a model from a fairly large db with 200+ tables and foreign keys.

get an error message

Code: Select all

The Action Restrict on  is not recognized. Valid actions are: None, Cascade, and Restrict. 


We are using the shareware version 2.50.50 (till our order comes through)

I've tried setting the fk action to cascade and none, and both are accepted. Only Restrict isn't.

When it started up it compained that all our fk relationships were called fkstkid, fkcustid, etc. I've changed all of them to be unique and there are still 60+ instances of this message.

Ideas?

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

Post by AndreyR » Thu 14 Jan 2010 14:39

Thank you for the report, I have reproduced the problem.
I will let you know about the results of our investigation.

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

Post by AndreyR » Tue 19 Jan 2010 15:51

Entity Framework does not provide the support for Restrict OnDelete Action.
But if you have ON DELETE RESTRICT in your foreign key definition, it will be set it in the model.
Microsoft acts in the same way. So the only solution is to manually change all Restrict OnDelete Actions.

Post Reply