Summary

This chapter looked at ADO.NET and some of its more advanced features. You have seen and used the main objects in ADO.NET that you need to quickly get up and running in order to build data-access into your .NET applications. You took a fairly in-depth look at the DataSet and DataTable classes, as these are the core classes of ADO.NET.

This chapter also looked at stored procedures, including how to create them in SQL Server and how to access them from your code. Finally, you looked at wrapping calls to the database in a transaction to allow them to be rolled back if necessary.