What?
The latest stable SqlClient is 7.0.0.
DAB is using 5.2.3 which is 2 major versions behind.
Why?
- Leaner, modular architecture. 7.0 was rewritten to be more lightweight with reduced dependencies
- Improved OpenIdConnect/Entra ID authentication support which will matter to MCP soon!
- Enhanced connection resiliency and retry logic. Just makes it all better.
- TDS 8.0 protocol support for stricter encryption
- Performance improvements across connection pooling and query execution
- Security patches accumulated over two major versions
Potential risks
- Major version bumps (5 → 6 → 7) typically include breaking changes in API surface, connection string behavior, and default encryption settings. It should be okay, but this will require some testing and research to be sure.
- SqlClient 6.0+ changed default encryption to
Mandatory, which might break connections, but we can account for it
- DAB's codebase has a note reminding devs to update scripts/notice-generation.ps1 when changing this package, suggesting there are known downstream impacts
What?
The latest stable SqlClient is
7.0.0.DAB is using
5.2.3which is 2 major versions behind.Why?
Potential risks
Mandatory, which might break connections, but we can account for it