Review
The following questions are intended to reinforce key concepts and information presented in this chapter. If you are unable to answer a question, return to the appropriate lesson and review, then try the question again. Answers to the questions can be found in Appendix A.What are the major components of a data provider, and what function does each fulfill?
Briefly contrast connected and disconnected data access in ADO.NET.
What are the four major parts of a SQL SELECT statement? Briefly describe each one.
In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are SQL statements executed?
What are the three possible settings for the CommandType property of a SqlCommand object or an OleDbCommand object, and what does each mean?
How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database using ADO.NET?
Briefly discuss the advantages and disadvantages of using typed DataSet objects.
How can you manage data currency on a form with several bound controls?
Describe how to use a DataView to filter or sort data.
Briefly describe an XmlDataDocument and how it relates to a DataSet.
What is meant by a SQL injection attack? How can you prevent one from occurring in your application?
How can you read XML data into a Dataset? How would you write data in a Dataset to an XML file? How would you retrieve a string representation of the XML contained within a Dataset? Describe each in general terms.