This chapter discusses how to access data from your C# programs using ADO.NET.The following details are covered:
¤ Connecting to the database – You learn how to use the SqlConnection and OleDbConnection classes to connect to and disconnect from the database.
¤ Executing commands – ADO.NET has command objects that can execute SQL commands or issue a call to a stored procedure with optional return values, You Learn the various command object options and see how commands can be used for each of the options presented by the sql and OleDE classes.
¤ Stored procedures – You learn 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- This is significantly different from the objects available with ADO. The DataSet, DataTable, DataRow, and DataColumn classes are discussed as well as the relationships between tables and constraints that are part of DataSet, The class hierarchy has changed significantly with version 2 of the .NET Framework, and some of these changes are also described.
¤ Using XMLand XMLschemas – You examine the XMLframework on which ADO.NET is built.
Microsoft has also added support for Language Integrated Query (LINQ), Although this topic largely supersedes the information.
As is the case with the other chapters, you can download the code for the examples used in this chapter from the csharp Web site at WWW.csharpaid.com