19.5. Summary

Both ADO.NET and JDBC provide a unified API for accessing any data store. Whereas the JDBC API is geared primarily toward an RDBMS, ADO.NET can be used to access data from text or XML streams.

The two key concepts of ADO.NET are the .NET data provider and the DataSet class. The .NET data provider is a set of classes for interfacing with a data source. A .NET data provider consists of all classes for connecting to the database, retrieving data, and running DML on the underlying RDBMS.

The DataSet class is an in-memory disconnected representation of the underlying RDBMS. The DataSet object can be used to programmatically run a subset of Data Definition Language and Data Modification Language. You can generate an entire database using ...

Get .NET for Java Developers: Migrating to C# now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.