Using the .NET Framework Data Provider for SQL Server 

This section describes features and behaviors that are specific to the .NET Framework Data Provider for SQL Server.

The .NET Framework Data Provider for SQL Server provides access to a SQL Server version 7.0 or later database using its own internal protocol. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for OLE DB, ODBC, and Oracle.

Note

To use the .NET Framework Data Provider for SQL Server, an application must reference the System.Data.SqlClient namespace.

In This Section

  • Using Query Notifications
    Describes how .NET Framework applications can request notification when the data currently in a result set has changed in the underlying database.
  • Using Snapshot Isolation
    Describes support for snapshot isolation, a SQL Server 2005 row versioning mechanism designed to reduce blocking by storing a version of data that one application can read while another application is modifying the same data within a transaction.
  • Performing Asynchronous Operations
    Describes how to perform asynchronous database operations using an API that is modeled after the asynchronous model used by the .NET Framework.
  • Using Connection Pooling
    Describes how connection pooling can enhance performance and scalability for database applications.
  • Working with User Instances
    Describes support for user instances in SQL Server Express 2005 using the .NET Data Provider for SQL Server (System.Data.SqlClient).

See Also

Other Resources

ADO.NET