ADO .NET Class Hierarchy

All ADO.NET functionality in the .NET Runtime class library comes in three general namespaces and n number of provider-specific namespaces. The three general namespaces are System.Data, System.Data.Common and System.Data.SqlTypes. Some of the provider-specific namespaces are System.Data.OleDb, Microsoft.Data.Odbc and System.Data.SqlClient.
The System.Data namespace defines classes that you can use with all the data providers or without data providers at all. This namespace also defines interfaces that are base classes for the data provider classes. Figure below shows the System.Data namespace's Class hierarchy.
Figure: The System.Data namespace class hierarchy
The System.Data.Common namespace defines classes common to all data providers. Figure below shows the System.Data.Common namespace hierarchy.
Figure: The System.Data.Common namespace hierarchy
The System.Data.SqlTypes namespace defines classes for native SQL server data types that provide type-safe conversion between the .NET data types and the SQL server native data types. Figure below shows the System.Data.SqlTypes namespace hierarchy.
Figure: The System.Data.SqlTypes namespace hierarchy.
Besides these three namespaces, ADO.NET defines n number of the provider-specific namespace. The class hierarchy models of all of these namespaces are similar except for the name of the class. The classes defined in the provider-specific namespaces start with the data provider name. For example, the Sql data provider classes start with Sql, and the OleDb data provider classes start with OleDb. The Command object classes of the Sql and OleDb data providers are SqlCommand and OleDbCommand, respectively.
In this section, you're going to see only the System.Data.OleDb namespace class hierarchy because all the data providers (including System.Data.Sql and Microsoft.Data.Odbc) implement the same class hierarchy model. Figure below shows the System.Data.OleDb namespace hierarchy.
Figure: The System.Data.OleDb namespace hierarchy


Hope this article would have helped you in understanding the ADO.NET class hierarchy provided by the .NET Runtime class library. See my other articles on the website on ADO.NET.

Similar Articles
Founded in 2003, Mindcracker is the authority in custom software development and innovation. We put best practices into action. We deliver solutions based on consumer and industry analysis.