Fix invalid constraint

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
dankolle
Posts: 5
Joined: Sat 06 Sep 2014 19:37

Fix invalid constraint

Post by dankolle » Thu 11 Sep 2014 13:53

I changed the type of my keys and now I am getting errors for the constraints. When I edit the constraints I see the mismatching types but I do not see how to change it.

Error:
"The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role."

Daniel

dankolle
Posts: 5
Joined: Sat 06 Sep 2014 19:37

Re: Fix invalid constraint

Post by dankolle » Thu 11 Sep 2014 18:40

Okay I found it.

You fix this not by editing the constraint or the related classes but by editing the table of the constraint shown in the model explorer.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Fix invalid constraint

Post by Shalex » Fri 12 Sep 2014 08:06

JIC: double click on the error in the Errors window should make the property/column with issue being active.

Post Reply