ADO.NET is microsoft's latest addition to their data access APIs.
Adjunct to DBlib, ODBC, DAO, RDO, ADO
System.Data namespace provides classes for working anytype of data.
Provides specific namespace allows for access to particular data source:
System.Data namespace contains disconnected of objects: DataSet, DataTable, DataRow, and so on...
- ADO works great, but requires COM and Windows. Recordset don't travel well across the internet.
- Connected behavior is hard to work with.
ADO.NET solves these problems: Use familiar concepts to perform familiar tasks. Use XML under the covers for data transport. XML has no runtime/transport requirements.
No special code requirement to marshal across the internet. ADO.NET requires new mind set. Most data activities disconnected Data Transport uses XML