SQL type display for current database only (bug or by design?)
Having already embarrassed myself by posting this as a feature request (sorry Joe), here's the issue...
When in SQL mode the connection tree shows SQL types and names for all objects on the currently selected database only. All other data contexts display .NET types and names, which makes it less usable when attempting to write queries that source data from other databases and/or servers.
Proposed Resolution: Connection list should show name and type information appropriate for the currently selected query language on all objects.
To replicate:
Used Version: LINQPad v4.47.02 Premium
When in SQL mode the connection tree shows SQL types and names for all objects on the currently selected database only. All other data contexts display .NET types and names, which makes it less usable when attempting to write queries that source data from other databases and/or servers.
Proposed Resolution: Connection list should show name and type information appropriate for the currently selected query language on all objects.
To replicate:
- Open an instance of LINQPad
- If only one single-database connection available add server connection with multiple databases
- Select connection for query and set language to SQL
- Expand objects in any other connection/database in connection tree
Used Version: LINQPad v4.47.02 Premium