Web Design that taps into the haromny and vision of your dreams.

What are Active Data Objects?

Active Data Objects, Microsofts Data Access Tools

Written By on in C#

276 words, estimated reading time 2 minutes.

Active Data Objects are a collection of classes and interfaces that manage database access withing the .Net Framework.

Active Data Objects (ADO.Net) Series
  1. What are Active Data Objects?
  2. Connecting to a SQL Server Database with C#
  3. Consuming Data in Windows Forms C# Applications
  4. Using ADO.Net Controls in ASP.Net Pages
  5. Modifying Data and Updating Databases with C#
  6. Connecting to MySql Databases with C# / ASP.Net
  7. Reading Excel Spreadsheets with C# ADO.Net
  8. Creating SQL Server Stored Procedures in C#
  9. Calling SQL Server Stored Procedures from C#
  10. Importing and Exporting XML from a DataSet

ADO.Net is the successor to ADO and has a much greater flexibility built in. ADO.Net is designed for disconnected environments where a query is executed on a SQL Server and the results are "downloaded" and stored locally.

Disconnected and Connected Systems

On a disconnected system a subset of the data is downloaded to the user and the local copy is modified, records added or removed, and then the changes are sent back to the server at a later time. This reduces SQL Server transactions and server load. Disconnected environments also allow other users to use the connection and improve the scalability and performance of applications. They are particularly useful for connections where there is limited bandwidth, i.e. database connections over a slow Internet line. The disadvantages of the connected system are that the data is not always up to date and change conflicts can occur.

Connected environments, on the other hand, require a constant connection to the database. All transactions are processed on the server in real-time meaning that the data is always up to date. This also leads to a more secure environment as data is not stored away from the server and locking records while a transaction is in process eliminates change conflicts.

ADO.Net Object Model

ADO Object Model
ADO Object Model

The database on the server (MSSql, Oracle, MySql etc...) is accessed by ADO.Net using the SqlConnection object. A SqlCommand object object is used to query the database and the results are stored in a SqlDataReader (connected mode) or a DataSet (disconnected mode) object. From these two objects you can manipulate the data or present it with a data aware control.

Last updated on: Friday 23rd June 2017


Himanshu Seervi

Himanshu Seervi

Thanks for the explanation. It is very helpful in understanding database connection using ADO.Net.
I would like more articles related to the same.

Reply to Himanshu Seervi


Leave a Reply

Your email address will not be published.

If you find something abusive or that does not comply with our terms or guidelines please flag it as inappropriate.

Copyright © 2001-2018 Tim Trott, all rights reserved. Web Design by Azulia Designs

This web page is licensed for your personal, private, non-commercial use only.

Disclaimer, Privacy & LegalSitemapContact Me