---
title: "ADO.NET Object Model and Attributes"  
description: "ADO.NET provides a set of classes for working with data. ADO.NET is a set of classes, interfaces, structures and enumerations that manage data access"  
author: "Amit Singh"  
published: 2010-11-30  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/61/ado-dot-net-object-model-and-attributes  
category: "ado.net"  
tags: ["ado.net"]  
reading_time: 1 minute  

---

# ADO.NET Object Model and Attributes

ADO.NET provides a set of classes for working with data. ADO.NET is a set of classes, interfaces, structures and enumerations that manage [data access](https://www.mindstick.com/blog/301551/risks-and-challenges-of-data-access-and-sharing) in the .net framework

##### ADO.NET has following attributes:

Consists of set of classes that you can use to connect to and [manipulate data](https://www.mindstick.com/forum/157877/how-do-you-use-filters-in-angularjs-to-manipulate-data) source

[Transfer data](https://www.mindstick.com/forum/34257/how-can-transfer-data-from-one-activity-to-another-activity-in-android) into xml format between the database and your [web application](https://www.mindstick.com/articles/13069/progressive-web-application-pwas-all-you-need-to-know-about) etc.

##### ADO.NET object model

ADO.NET [object model](https://www.mindstick.com/forum/158432/what-is-the-document-object-model-dom-and-how-does-it-relate-to-web-development) provides an infrastructure that you can use to [access data](https://www.mindstick.com/forum/159853/how-to-access-data-using-entity-framework-in-asp-dot-net-mvc) from different Data Sources.\
There are two main component of this object model\
Dataset and .Net [data provider](https://www.mindstick.com/forum/237/what-is-the-difference-between-database-driver-and-data-provider)\
\

| ## Dataset |  |  |  |
| --- | --- | --- | --- |
| Datatable | DataTable |  |  |
| Odbc provider | Sqlserver data provider | Oledb.Netprovider | Oracle Dataprovider |
| Odbc sources | Sqlserver | Oledb sources | Oracle sources |

Fig:ADO.NET Object Model

##### How accesing data with ADO.NET

- Client makes request
- Create a sqldatasource
- Return the data to the client
- Update the data
- Use the SQLdatasource to open a data base connection, [update the database](https://www.mindstick.com/forum/160254/how-to-apply-a-migration-to-update-the-database-schema-in-entity-framework-core) and [close the connection](https://www.mindstick.com/forum/87/how-use-the-dispose-method-for-close-the-connection)

\

---

Original Source: https://www.mindstick.com/blog/61/ado-dot-net-object-model-and-attributes

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.