Conclusion

Conclusion

In this chapter you learned how to set up a connection to a database and retrieve data. That data was brought into an in-memory data set via a data connector. We modified the data and sent it back to update its source. The main objects that we became friends with were the following:

• Connection. For connecting to and managing transactions against a database.

• Command. For issuing SQL commands against a database.

• DataReaders. For reading a forward-only stream of data records from an SQL Server data source.

• DataSets. For storing, remoting, and programming against flat data, XML data, and relational data.

• DataAdapters. For pushing data into a DataSet and reconciling data against a database.

Now we are ready to move on to explore some of the finer parts of ADO.NET.