In Brief

This chapter presented advanced features of ADO.NET you can use to more easily work with your data dynamically, as well as explained the details of some of the “magic” that Visual Studio .NET does for you:

• ADO.NET provides lots of flexibility and power, such as attaching a ConnectionString to an attribute in an XML file.

• The command class allows you to call SQL statements directly as well as stored procedures. You can also set up parameters to make your queries more manageable and secure.

• Sending data back to your database is easy and flexible using the Command and DataAdapter classes.

• You can accomplish many tasks with some of the extra classes like DataView and Transaction, while saving queries and helping data integrity.