ADO.NET Programming Model

The ADO.NET programming model is built around two groups of objects: Managed provider objects: These objects provide direct, connected access to a data source and the ability to directly interact with a data source. This group includes the Connection, Command, DataAdapter, and DataReader objects. The DataReader object provides streaming, forward-only, read-only access to a data source and is the fastest way to access a data source. The DataSet object: This object provides disconnected access to a data source, that is, without a persistent connection to the parent data source. In fact, the DataSet…Read more …

What are the benifits of ADO.NET?

ADO.NET brings with it a number of benefits, which fall into the following categories: Interoperability The ability to communicate across heterogeneous environments.  ADO.NET addresses the common data-exchange limitation by using XML as its payload data format. Since XML is text-based and simple to parse, it's a good choice for a common, platform-independent, and transportable data format. Furthermore, because XML is nothing more than structured text, employing XML as the data format on top of the HTTP network protocol minimizes firewall-related problems. With ADO and its XML format, the clients do not have to…Read more …