Summary
This chapter has provided an overview of the data access capabilities provided by ADO.NET. The ADO.NET Data Provider architecture provides functionality comparable to that of JDBC. Although the .NET DataReader lacks some of the more advanced functionality of the ResultSet, the consolidation of the Command classes and the use of C# properties and indexers often results in cleaner code, in our opinion.
The ADO.NET DataSet offers functionality similar to that of the JDBC RowSet interface. A DataSet can place heavy demands on the memory of a system and can be complex to configure correctly; however, the disconnected data management capabilities and extensive support for XML integration of a DataSet make it a valuable tool to simplify the development ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access