juniorADO.NET
What is SqlConnection in ADO.NET?
Updated Apr 28, 2026
Short answer
SqlConnection is used to establish a connection to SQL Server.
Deep explanation
It represents a connection session with the database. It uses connection strings and supports connection pooling for performance.
Real-world example
Opening DB connection for CRUD operations.
Common mistakes
- Forgetting to dispose connection.
Follow-up questions
- What is connection pooling?
- Why use using statement?