ADO.NET provides the database access for Microsoft.NET. XML is used in ADO.NET for in-memory middle-tier business objects, or DataSets, built at run-time from EIS-tier databases. The DataSets are a copy of the data in the database and are not actively connected to the underlying databases. This is referred to as a "disconnected" view of the database data. ADO.NET is designed to work with all the languages supported in .NET. ADO.NET can be used with virtually any database management system.
ADO.NET uses the call-level approach. This is illustrated by the ADO.NET statements in this diagram:
An example of a host statement in C# that creates a new Person instance, or DataRow, would be:
DataRow row = ds.Tables["Person"].NewRow();
row["ssan"] = "999999999";
row["name"] = "Doug Barry";
If you also wanted to manipulate this new Person instance in the host program, you would need C# code in addition to this code fragment that populates the instance in C# along with the instance in the database.
Also see .NET.
More on the general topic: DBMS Standards
- Java Data Objects (JDO)
- ODMG 3.0
- Detailed Comparison of ODMG 3.0 and JDO
- Summary Comparison of DBMS Standards