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 Books Online

  1. Development (Database Engine)

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.

SQL Server Common Language Runtime Integration
Describes how data can be accessed from within a common language runtime (CLR) database object in SQL Server.

Query Notifications in SQL Server
Describes how .NET Framework 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 (AlwaysOn) availability groups.

SqlClient Support for LocalDB
Describes SqlClient support for LocalDB databases.

SQL Server Data Operations in ADO.NET
Retrieving and Modifying Data in ADO.NET
LINQ to SQL
SQL Server and ADO.NET
ADO.NET Managed Providers and DataSet Developer Center

Show: