CONTENTS
Implementing LookUpPetName() .......................................................................................................... 852
Understanding Database Transactions..........................................................................853
Key Members of an ADO.NET Transaction Object................................................................................. 854
Adding a CreditRisks Table to the AutoLot Database ........................................................................... 855
Adding a Transaction Method to InventoryDAL .................................................................................... 856
Testing Your Database Transaction...................................................................................................... 857
Summary .......................................................................................................................858
Chapter 22: ADO.NET Part II: The Disconnected Layer........................................859
Understanding the Disconnected Layer of ADO.NET......................................................859
Understanding the Role of the DataSet..........................................................................861
Key Properties of the DataSet............................................................................................................... 861
Key Methods of the DataSet ................................................................................................................. 862
Building a DataSet ................................................................................................................................ 863
Working with DataColumns ...........................................................................................864
Building a DataColumn ......................................................................................................................... 865
Enabling Autoincrementing Fields........................................................................................................ 866
Adding DataColumn Objects to a DataTable ......................................................................................... 866
Working with DataRows ................................................................................................867
Understanding the RowState Property ................................................................................................. 868
Understanding the DataRowVersion Property ...................................................................................... 870
Working with DataTables...............................................................................................871
Inserting DataTables into DataSets ...................................................................................................... 872
Obtaining Data in a DataSet .............