Summary

This chapter gives you a starting point for the effective use of ADO.NET. You've learned how to use the SqlConnection, SqlCommand, and SqlDataReader objects. You've also learned how to add parameters to a command and how to call a stored procedure.

A complete and reusable application was introduced to illustrate the ADO.NET topics that were presented. Along the way, best practices and design patterns were presented that will assist you in developing robust applications.

Although this chapter provides 90 percent of what you need for database access, Chapter 4 covers more advanced ADO.NET topics.