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 ...
Get C# for Java Developers 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.
