Devart Forums

Posted: **Thu 14 Jan 2010 12:10**

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

get an error message

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?

Posted: **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.

Posted: **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.

Devart Forums

The Action Restrict on <tablename> not recognized.

The Action Restrict on <tablename> not recognized.