Dump() not generating navigation properties for large tables
When querying a table with a large number of columns, navigation properties are not appended to the table.
In particular, Table A I'm querying has 41 columns and does not produce the navigation properties.
Table B with 29 columns does produce the navigation properties.
We have a 1:Many (one table B for many table A). The link from TableB -> TableA does show, and it's not an issue with foreign keys, I suspect it's a hard limit we've crossed excluding the properties from generating
Robert Rudman
shared this idea
-
Karl Werner commented
If there are performance concerns here, a nice option would be to have a manual button to tell it to go ahead and load links for the given result row.
-
Edward Lynch
commented
The motivation for my votes comes from being in a new database I am not familiar with and there being a table with lots of relationships - and since a lot of things center around it, it is harder to explore and gain an understanding of the data quickly by using the links. There are at least the links in the table listing on the left but not being able to click to the data itself makes this process slower.
-
Anonymous commented
There is a configuration hidden in LINQPad to show / hide relations depends on number of them to improve performance.
http://forum.linqpad.net/discussion/1141/no-navigation-properties-in-rich-text-view
I hope they will implement option to configure it.