Overview of ADO.NET - Part 1

Posted by in ADO.NET category on for Beginner level | Points: 250 | Views : 7989 red flag
Rating: 4.67 out of 5  
 3 vote(s)

We will see overview of ADO.NET. This is the first part of the ADO.NET Series article.


ADO.NET is a set of classes that together allow your applications to interact with the information stored in a database.

The main difference between ADO.NET and its earlier version, ADO (ActiveX Data Object), is that ADO.NET uses a disconnected architecture. This means that ADO.NET doesn't work directly on the information in the database but on a local copy of that information.

A DataSet object is a cache used to store data from the database on your local machine. You work on the dataset, making changes to the data contained there.

You then create a new DataSet object containing only the changes that have been made to the data, and you upload those changes to the original database.

All communications and data changes between the dataset and the database in ADO.NET are handled by these namespaces:

  • System.Data 
  • System.Data.Common 
  • System.Data.OleDb 
  • System.Data.SqlClient 
  • System.Data.SqlTypes 


The System.Data namespace defines the generic types that represent data, including the Table, Row, Column, Constraint, and DataSet types. 


The System.Data.Common namespace contains the types shared by the managed providers that handle the transmission of data between the dataset and database. 


The types in the System.Data.OleDb namespace allow you to connect to OLE databases, executing SQL commands and populating datasets. 


The types in the System.Data.SqlClient namespace are used by the SQL-managed providers that connect to Microsoft SQL Server. 


The types in the System.Data.SqlTypes namespace are optimized to represent the data types used by Microsoft SQL Server itself. 

ADO.NET is closely integrated with XML. You can now present the data in a database as an XML document rather than a set of tables, and XML is used to transmit data. This has two main advantages:

Bypasses Firewalls 
Improves Processing Time 

Bypasses Firewalls 

Because ADO.NET uses XML, which is transmitted over HTML port 80, it passes through most company firewalls. 

Improves Processing Time 

ADO uses COM to manage the transmission of data, which means that all data has to be translated into the types recognized by COM before being translated back to the database types. This involves a large processing overhead, which ADO.NET avoids by using XML.

Thanks and Have Fun!!!!!
Page copy protected against web site content infringement by Copyscape

About the Author

Full Name: John Doe
Member Level: Bronze
Member Status: Member,MVP
Member Since: 1/22/2011 7:38:35 AM
Country: India

Login to vote for this post.

Comments or Responses

Posted by: Akiii on: 2/23/2011 | Points: 25
Thank you for posting overview for ADO.NET
Looking forward for more.

Posted by: Naimishforu on: 2/23/2011 | Points: 25
Sure Akiii :)

Posted by: Akiii on: 2/23/2011 | Points: 25
Hi Naimish, can you tell me what are the data types in System.Data.SqlTypes which is used by sql server itself ? and when should we import this namespace ?

Thanks and Regards
Posted by: Naimishforu on: 2/23/2011 | Points: 25
Hi Akiii,

You may check out the below link, once you read it, your doubts will get clear :)

Posted by: Akiii on: 2/24/2011 | Points: 25
Thank you Naimish for the link, much appreciated.
The main point is - Using the classes of System.Data.SqlTypes will help prevent type conversion errors caused by loss of precision. Because other data types are converted to and from SqlTypes behind the scenes, explicitly creating and using objects within this namespace also yields faster code.

the above extract is taken taken from the msdn, the link that you have provided to me.


Login to post response

Comment using Facebook(Author doesn't get notification)