SQL Server features and ADO.NET

Download ADO.NET

The topics in this section discuss features in SQL Server that are targeted at developing database applications using ADO.NET.

For more information, see Development (Database Engine) from SQL Server Books Online.

In this section

Enumerating instances of SQL Server (ADO.NET)
Describes how to enumerate active instances of SQL Server.

Provider statistics for SQL Server
Describes support for obtaining SQL Server run-time statistics.

SQL Server Express user instances
Describes support for SQL Server Express user instances.

Database mirroring in SQL Server
Describes database mirroring functionality.

The context connection
Describes the context connection.

Query notifications in SQL Server
Describes how .NET applications can request notification from SQL Server when data has changed.

Snapshot isolation in SQL Server
Describes support for snapshot isolation, a row versioning mechanism designed to reduce blocking in transactional applications.

SqlClient support for high availability, disaster recovery
Describes SqlClient support for high-availability, disaster recovery (Always On) availability groups.

SqlClient support for LocalDB
Describes SqlClient support for LocalDB databases.

SqlClient support for Always Encrypted
Describes SqlClient support for the Always Encrypted feature.

SqlClient support for Data Discovery and Classification
Describes how to access Data Discovery and Classification information through SqlClient.

Next steps