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 [...]
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, [...]