clickable foreign keys in result pane
for results from database, make clickable the value of the column, which is foreign key (for example Table.Take(x) -> results to [TableID, ForeignID] - clickable values from ForeignID column -> on click runs ForeignTable.Where(i => i.ID == Table.ForeignID).Take(x)
Completed in v4.37. Click the ‘Results to Grids’ button to enable this feature.
-
Stefan Bertels commented
Great feature. Can the link text be something specific?
I currently have a foreign key column "StartOtherId" (FK name = column name, target table is named Other). LinqPad shows this column as plain number column (without link) and additionally a column "StartOther" as Link. The link text is "StartOther" in every line (until I expand that item).
Suggestion 1: Maybe both columns should be merged or at least be neighbors in output.
Suggestion 2: Link text should be distinguishable.
Caption could be the ID value. Might be great to display even more, e.g. some "Name" property of the target item (Other[StartOtherId].Name), but I see the performance/lookup problem. I have in mind: ToString and DebuggerDisplay. Don't know whether there is something I could add to my SQL server tables to make this work.