Writing Provider-Independent Code in ADO.NET
The System.Data.Common namespace provides generic classes for working with data. These classes are intended to give developers a way to write ADO.NET code that will work against all .NET Framework data providers.
In This Section
- Overview of the Provider Independent Model
-
Provides an overview of the factory design pattern and programming interface.
- Enumerating Installed Data Providers
-
Demonstrates how to retrieve information about the .NET Framework data providers installed on the local computer.
- Working with Factories
-
Demonstrates how to work with factories to access data sources across multiple providers.
Related Sections
- What's New in ADO.NET
-
Introduces features that are new in ADO.NET.
- Overview of ADO.NET
-
Provides an introduction to the design and components of ADO.NET.
- Securing ADO.NET Applications
-
Describes secure coding practices when using ADO.NET.
- Using DataSets in ADO.NET
-
Describes how to create and use a DataSet, a typed DataSet, a DataTable, and a DataView.
- Connecting and Retrieving Data in ADO.NET
-
Describes how to connect to a data source and retrieve data, including DataReaders and DataAdapters.
- Modifying Data in ADO.NET
-
Describes how to modify data in a database and how to use transactions.
- Using the .NET Framework Data Provider for SQL Server
-
Describes how to work with features and functionality that are specific to SQL Server.
- Using the .NET Framework Data Provider for Oracle
-
Describes features and behaviors that are specific to the .NET Framework Data Provider for Oracle.
- Using SQL Server Common Language Runtime Integration
-
Describes how data can be accessed from within a common language runtime database object in SQL Server 2005.
- Performing General Tasks in ADO.NET
-
Describes how to use various general-purpose features of ADO.NET.
- Finding Additional ADO.NET Information
-
Provides links to additional online information about ADO.NET.