Tringle SP Navigator
Quick navigation from C# code to SQL Server Stored Procedures.
Features
- Go to SP: Jump directly from
SpCall("dbo.sp_name") pattern in C# code to the stored procedure definition
- Search SP: Search stored procedures by name with LIKE pattern
- Recent SPs: Quick access to recently opened stored procedures
- Favorites: Save frequently used stored procedures for quick access
- Sidebar Panel: Dedicated activity bar with connection info, search, recent, and favorites views
Usage
Keyboard Shortcut
- Place cursor on a line containing
SpCall("dbo.sp_name") pattern
- Press
Alt+F12 to open the stored procedure
- Right-click on a line with SpCall pattern in C# files
- Select "Go to SP"
- Click the database icon in the activity bar
- Use the search panel to find stored procedures
- Click on any SP to view its code
Configuration
Open VS Code Settings and search for "SP Navigator":
| Setting |
Description |
Default |
spNavigator.server |
SQL Server address |
(localdb)\MSSQLLocalDB |
spNavigator.database |
Database name |
TestDB |
spNavigator.useWindowsAuth |
Use Windows Authentication |
true |
spNavigator.username |
SQL Server username (if not using Windows Auth) |
|
spNavigator.password |
SQL Server password (if not using Windows Auth) |
|
spNavigator.recentLimit |
Maximum number of recent SPs to remember |
20 |
Requirements
- SQL Server instance (SQL Server, Azure SQL, etc.)
- Windows Authentication or SQL Server Authentication credentials
Known Limitations
- LocalDB is not supported (uses shared memory, not TCP/IP)
- Windows Authentication requires the msnodesqlv8 native driver
Release Notes
1.4.0
- Added extension icon
- Added MIT license
- Improved marketplace presentation
1.3.0
- Migrated to mssql package for better cross-platform support
- Added Windows Authentication support via msnodesqlv8
- Internationalized all strings to English
1.2.0
- Added sidebar panel with connection, search, recent, and favorites views
- Added favorite SPs feature
1.1.0
- Added recent SPs tracking
- Added search functionality
1.0.0
- Initial release with basic SpCall navigation
| |
