Database Reference
In-Depth Information
Table 10-1.
ADO.NET Namespaces
Namespace
Description
System.Data
Classes, interfaces, delegates, and enumerations that define and
partially implement the ADO.NET architecture
System.Data.Common
Classes shared by .NET Framework data providers
System.Data.Design
Classes that can be used to generate a custom-typed data set
System.Data.Odbc
The .NET Framework data provider for ODBC
System.Data.OleDb
The .NET Framework data provider for OLE DB
System.Data.Sql
Classes that support SQL Server-specific functionality
System.Data.OracleClient
The .NET Framework data provider for Oracle
System.Data.SqlClient
The .NET Framework data provider for SQL Server
System.Data.SqlServerCe
The .NET Compact Framework data provider for SQL Server Mobile
System.Data.SqlTypes
Classes for native SQL Server data types
Microsoft.SqlServer.Server
Components for integrating SQL Server and the CLR
Since XML support has been closely integrated into ADO.NET, some ADO.NET components in the
System.Data
namespace rely on components in the
System.Xml
namespace. So, you sometimes need to
include both namespaces as references in Solution Explorer.
These namespaces are physically implemented as assemblies, and if you create a new application
project in VCSE, references to the assemblies should automatically be created, along with the reference
to the
System
assembly. However, if they're not present, simply perform the following steps to add the
namespaces to your project:
1. Right-click the References item in Solution Explorer; then click Add Reference.
2. A dialog box with a list of available references displays. Select
System.Data
,
System.Xml
, and
System
(if not already present) one by one (hold down the Ctrl
key for multiple selections); then click the Select button.
3. Click OK, and the references will be added to the project.
