When dragging an entity into a entity diagram, show all related entities.
65
Views
4
Comments
New
Service Studio

When dragging an entity into an entity diagram it would be most useful if all related entities would be automatically added to the ERD. 

Example of usage.

Say you need to clean up records in the database for some reason. Ensuring database integrity and delete rules the related children should be deleted first before deleting the parent entities. By dragging the parent entity into the entity diagram would show all related entities which would greatly enhance insight in the logic one needs to create.

I forgot to mention why this would be useful.

It is apparent to detect the parent entities via the foreign keys but one cannot detect the child entities via the primary keys. A find usages by right-clicking on a primary key will not show its child entities either.

Could be a CTRL-drag which in other programs means add and turns the mouse cursor into a [+]. I don't think I want all entities every time, that would be annoying, but having the option to do sometimes would be clever.

CTRL-drag does not work, Soren. However, upon dragging an entity in the entity diagram and right-clicking on the entity opens a speed menu with the options "Show all entities reference by ..." and "Show all entities that refer ...".

The "Show all entities referenced by.." will add all parent entities and their joins to the ERD and the "Show all entities that refer.." will add all child entities and their join to the ERD.

That kind of makes this idea unnecessary. 

Hey @chris, 

Yeah I know it doesn't work right now, but it was a suggestion for how to implement the feature :) I'd like people who drag to have both options, both yours and the normal (single drag) one.