Microsoft.Data.SqlClient
Microsoft.Data.SqlClient: A free embedded .NET driver with default client-side pooling for SQL Server and Azure SQL. Ranked #8 of 29 in Database Connection Pooling Software by our editors (8.2/10); pricing: Free plan; best for SQL Server and Azure SQL applications.
At a glance
- Editor score8.2 / 10
- PricingFree plan
- Best forSQL Server and Azure SQL applications
- Free planYes
- Paid fromFree
- Transaction poolingNo
- Facts checked14 Nov 2026
Where it wins
- Connection pooling is enabled by default, with configurable pool sizes.
- Supports async connection opening, command execution, and transactions.
- Offers Entra ID authentication options and strict TLS encryption.
Where it doesn't
- Supports SQL Server and Azure SQL only.
- Pooling is client-side and embedded, not a standalone pooling service.
- Does not provide transaction pooling.
Our verdict on Microsoft.Data.SqlClient
Microsoft.Data.SqlClient is a free, open-source .NET data provider for applications connecting to SQL Server and Azure SQL. It supplies APIs to open connections, execute SQL commands, read results, and manage transactions, with support for Windows, Linux, and macOS. Its client-side connection pooling is enabled by default: when an application opens a connection, the provider can reuse an authenticated physical connection from a matching pool, and disposing of the connection returns it to that pool. This makes it a fit for teams building .NET applications that need database access and pooling within the application rather than through a separate service.
Pooling behavior is configurable through connection-string options, including minimum and maximum pool size. Pool keys take account of connection configuration and authentication identity, which can affect whether connections share a pool. The provider also supports asynchronous connection opening and command execution, local and ambient transactions, and SQL command and data-reader APIs. For applications that need authentication options, Microsoft Entra ID is supported; TLS modes include strict encryption. The documented default maximum pool size is 100 per pool. These capabilities make the driver useful when pooling needs to be managed alongside application connection behavior, rather than by a separate intermediary.
The scope is deliberately tied to SQL Server and Azure SQL, using the Tabular Data Stream protocol. It is embedded and self-hosted as part of an application, not a standalone database connection-pooling service, and it does not offer transaction pooling. Choose it when the application is built on .NET and targets either supported database; look elsewhere if you need one pooling layer across other database systems or a separate pooling service. Its fit spans small, mid-market, and enterprise organizations, but database compatibility remains the deciding constraint.
Your product? Our editors can test Microsoft.Data.SqlClient in depth and publish a review, labelled as paid · from $149/mo →
Microsoft.Data.SqlClient pricing
Microsoft.Data.SqlClient fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Free |
| Transaction pooling | No |
| Pooling modes | Not verified |
| Deployment model | Embedded |
| Supported databases | SQL Server; Azure SQL |
| Connection limit | Not verified |
| Protocol support | Tabular Data Stream (TDS) |
| Deployment | Self-hosted |
| Platforms | Windows, Linux, macOS |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 2 integrations: SQL Server, Azure SQL |
| Pricing | Free plan |
| Website | learn.microsoft.com |
| Facts checked | 14 Nov 2026 |
Microsoft.Data.SqlClient integrations
Microsoft.Data.SqlClient lists 2 integrations on its own site.
- SQL Server
- Azure SQL
Alternatives to Microsoft.Data.SqlClient
- MariaDB MaxScaleSQL-aware pooling and routing for MariaDB and MySQL-compatible production environments.9.3
- OdysseyA focused, open-source pooler for PostgreSQL session and transaction workloads.9.1
- PgBouncerA self-hosted PostgreSQL pooler with flexible modes and connection controls, but no built-in failover.8.9
See all Microsoft.Data.SqlClient alternatives →
Microsoft.Data.SqlClient vs the competition
- Microsoft.Data.SqlClient vs MariaDB MaxScale
- Microsoft.Data.SqlClient vs Odyssey
- Microsoft.Data.SqlClient vs PgBouncer
- Microsoft.Data.SqlClient vs Apache Commons DBCP
- Microsoft.Data.SqlClient vs Tomcat JDBC Connection Pool
- Microsoft.Data.SqlClient vs Vert.x Reactive SQL Clients
Compare Microsoft.Data.SqlClient with any tool side by side →
Used Microsoft.Data.SqlClient? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Microsoft.Data.SqlClient for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Microsoft.Data.SqlClient is listed in our Database Connection Pooling Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/microsoft-data-sqlclient/"><img src="https://www.itechguides.com/best/badge/microsoft-data-sqlclient.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Nov 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update