I loaded a v4.2 project in v5 and noticed a whole lot of 'DZ0025: For the database with driver 'SQL Server 2000-2016/Express Driver (SqlClient)', the relationship xxxyyy This conflicts with the setting 'RelationshipsFollowDBForeignKeyConstraints' which is set to true and the containing schema is synced with an external database for '
These were all for relationships from an entity mapped to a view, most of the relationships were set as 'Is Model Only' but the ones that weren't gave me this error. I can easily change them to 'Is Model Only' but, it seems to me, a redundant setting as all relationships on a view-mapped entity could only ever be 'Is Model Only'. (BTW there is a hyphen in the context menu but not in the relationship editor i.e. Model-Only )
Is there any case where this setting (and its warning) is useful for a view-mapped entity, maybe when its mapped to a view in one relational model but to a table in another?
I ask because I wasted some time on this, trying to work out why the relationship wasn't showing in the catalog, before I remembered the entity was mapped on to a view.