Microsoft® Visual J#™ .NET (Core Reference)

Summary

ADO.NET provides a disconnected data access model through classes in the System.Data namespace. In this chapter, we looked at many of the day-to-day tasks involved in developing .NET applications. You learned how to connect to a data store and execute SQL commands and stored procedures against it. At the heart of these operations is a DataAdapter, which acts as a bridge between a data source and a DataSet. The DataSet provides a local cache of data, which you can navigate much like you do a relational database. The DataSet consists of tables, columns, and rows that you can perform select, update, insert, and delete operations against. You also learned how ADO.NET embraces XML as a format for persisting and transferring data and for creating ...