SQL Server Features and 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 SQL Server Books Online for the version of SQL Server you are using, as listed in the following table.

SQL Server 2000 Books Online	SQL Server 2005 Books Online	SQL Server 2008 Books Online
Building SQL Server Applications Overview	SQL Server Programming Overview	Development (Database Engine)

In This Section

Enumerating Instances of SQL Server (ADO.NET)
Describes how to enumerate active instances of SQL Server.
Provider Statistics for SQL Server (ADO.NET)
Describes support for obtaining SQL Server run-time statistics.
Connecting to SQL Server Express User Instances (ADO.NET)
Describes support for SQL Server Express user instances.
Database Mirroring in SQL Server (ADO.NET)
Describes database mirroring functionality.
SQL Server Common Language Runtime Integration (ADO.NET)
Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server.
Query Notifications in SQL Server (ADO.NET)
Describes how .NET Framework applications can request notification from SQL Server when data has changed.
Snapshot Isolation in SQL Server (ADO.NET)
Describes support for snapshot isolation, a row versioning mechanism designed to reduce blocking in transactional applications.