WHAT’S IN THIS CHAPTER?
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
This chapter discusses how to access data from your C# programs using ADO.NET. It shows you how to use the
OleDbConnection classes to connect to and disconnect from the database. You learn the various command object options and see how commands can be used for each of the options presented by the
OleDB classes; how to call stored procedures with command objects; and how the results of those stored procedures can be integrated into the data cached on the client.
The ADO.NET object model is significantly different from the objects available with ADO. This chapter covers the
DataSet, DataTable, DataRow, and
DataColumn classes as well as the relationships between tables and constraints that are part of
DataSet. The class hierarchy has changed significantly since the release of the .NET Framework 2.0, and some of these changes are also described. Finally, you examine the XML framework on which ADO.NET is ...