Is there a way to prevent the designer from re-implementing relations that where removed from the designer after the initial setup.

Eg. relation object A -> Object B is picked up during the initial setup in the designer. Then we manually remove it in the designer but after a sync (database sync) the relations are added again to the designer.

We use database first.

Delete rules that are updated we can live with but it is very annoying that relationships are added again.

I also cannot find an option to turn this off.

Please uncheck the following setting.

Project Settings -> Entity Model \ Database First Development -> Relationships Follow db foreign key constraint.

Cheers, I missed that setting.

One more question, this setting will not prevent newly added objects to have the correct relations based on db PK's and Fk's set in the designer correct?

No, it won't.

Since you are working Model first, model relations will be preserved.

Thx