Writing Provider Independent Code in ADO.NET
The System.Data.Common namespace provides generic classes for working with data that let you write code that can work across different data providers, as long as the data is isomorphic. However, this does not take into account differences between providers and database servers, which need to be handled by the developer on a case-by-case basis.
In This Section
- Provider Independent Model Overview
-
Provides an overview of the Common Model programming interface.
- Working with Factories
-
Provides examples demonstrating how to work with factories to access databases 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 DataSets, typed DataSets, DataTables, and DataViews.
- 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.