Table of content

	Table of Contents
	Index
	Reviews
	Examples
	Reader Reviews
	Errata

ADO.NET in a Nutshell
By Bill  Hamilton, Matthew  MacDonald
Publisher	: O'Reilly
Date Published	: April 2003
ISBN	: 0-596-00361-7
Pages	: 620
	Copyright
		Preface
			Audience
			Contents of This Book
			What's on the CD-ROM
			Conventions Used in This Book
			Comments and Questions
			Acknowledgments
		Part I:   ADO.NET Tutorial
			Chapter 1.   Introduction
				Section 1.1.   ADO.NET Data Providers
				Section 1.2.   Connected and Disconnected Data
			Chapter 2.   .NET Data Providers
				Section 2.1.   Data Providers
				Section 2.2.   Selecting a Data Provider
				Section 2.3.   Creating a Custom Data Provider
			Chapter 3.   Connections
				Section 3.1.   Connection Object Overview
				Section 3.2.   The Connection String
				Section 3.3.   Opening and Closing Connections
				Section 3.4.   Connection Pooling
			Chapter 4.   Commands
				Section 4.1.   Command Object Overview
				Section 4.2.   Creating and Executing a Command
				Section 4.3.   Parameter Object Overview
				Section 4.4.   Parameterized Commands
				Section 4.5.   Commands with Stored Procedures
				Section 4.6.   Commands and Data Definition Language (DDL)
			Chapter 5.   DataReaders
				Section 5.1.   DataReader Object Overview
				Section 5.2.   Performing a Query with a DataReader
				Section 5.3.   Stored Procedures with the DataReader
				Section 5.4.   DataReaders and Schema Information
			Chapter 6.   DataSets
				Section 6.1.   Creating an Untyped DataSet
				Section 6.2.   Working with Tables in the DataSet
				Section 6.3.   Adding and Removing Relations
				Section 6.4.   Adding Custom Information
				Section 6.5.   Cloning the Schema
				Section 6.6.   Copying the DataSet
				Section 6.7.   Merging Two DataSets
				Section 6.8.   Removing All Data
				Section 6.9.   Resetting the DataSet
				Section 6.10.   Committing and Discarding Changes
			Chapter 7.   DataTables
				Section 7.1.   Creating a DataTable
				Section 7.2.   Working with Columns
				Section 7.3.   Constraints
				Section 7.4.   Primary Key
				Section 7.5.   Rows
				Section 7.6.   Loading Data
				Section 7.7.   Committing and Discarding Changes
				Section 7.8.   Cloning the Schema of the Table
				Section 7.9.   Copying the Table
				Section 7.10.   Selecting a Subset of Rows
				Section 7.11.   Performing Aggregate Calculations
				Section 7.12.   Removing All Data
				Section 7.13.   Resetting the Table
				Section 7.14.   Identifying Errors in the Table
				Section 7.15.   DataTable Events
			Chapter 8.   DataColumns
				Section 8.1.   Creating DataColumns
				Section 8.2.   Creating AutoIncrement Columns
				Section 8.3.   Creating Expression Columns
				Section 8.4.   Handling Null Values
				Section 8.5.   Mapping .NET Data Provider Types to .NET Framework Types
			Chapter 9.   DataRows
				Section 9.1.   Creating a DataRow
				Section 9.2.   Updating Rows
				Section 9.3.   Deleting Rows
				Section 9.4.   Using Row State Information
				Section 9.5.   Using Row Version Information
				Section 9.6.   Accepting or Rejecting Changes to Rows
				Section 9.7.   Navigating Parent and Child Rows
				Section 9.8.   Using Row Error Information
			Chapter 10.   Constraints
				Section 10.1.   Constraint Object Overview
				Section 10.2.   The UniqueConstraint
				Section 10.3.   The ForeignKeyConstraint
			Chapter 11.   DataRelations
				Section 11.1.   DataRelation Object Overview
				Section 11.2.   Navigating Relational Data
			Chapter 12.   DataViews and Data Binding
				Section 12.1.   The DataView and DataViewManager
				Section 12.2.   Sorting and Filtering
				Section 12.3.   Accessing Data Through a DataView
				Section 12.4.   Windows Data Binding
				Section 12.5.   ASP.NET Data Binding
			Chapter 13.   Strongly Typed DataSets
				Section 13.1.   Creating a Strongly Typed DataSet
				Section 13.2.   Adding a Row
				Section 13.3.   Editing a Row
				Section 13.4.   Finding a Row
				Section 13.5.   Null Data
				Section 13.6.   Navigating Hierarchical Data
				Section 13.7.   Annotations
			Chapter 14.   DataAdapters
				Section 14.1.   Creating DataAdapter Object
				Section 14.2.   Retrieving Data from the Data Source
				Section 14.3.   Retrieving Schema Information from the Data Source
				Section 14.4.   Updating the Data Source
				Section 14.5.   Mapping Tables and Columns
				Section 14.6.   AcceptChangesDuringFill
				Section 14.7.   ContinueUpdateOnError
				Section 14.8.   DataAdapter Events
			Chapter 15.   Updating the Data Source
				Section 15.1.   SqlCommandBuilder Class Overview
				Section 15.2.   Updating a Data Source Using Command Builder
				Section 15.3.   Updating a Data Source Using Custom Logic
				Section 15.4.   Refreshing Data After Updating
				Section 15.5.   Retrieving Updated Values from the Data Source
				Section 15.6.   Updating Data in Related Tables
				Section 15.7.   Handling Concurrency Issues
				Section 15.8.   Optimization
			Chapter 16.   Transactions
				Section 16.1.   Manual Transactions
				Section 16.2.   Isolation Levels
				Section 16.3.   Savepoints
				Section 16.4.   Nested Transactions
				Section 16.5.   Transactions Using a DataAdapter
				Section 16.6.   Automatic Transactions
			Chapter 17.   XML and the DataSet
				Section 17.1.   DataSet XML Methods
				Section 17.2.   Shaping DataSet XML
				Section 17.3.   Other .NET XML Classes
				Section 17.4.   XmlDataDocument Object Overview
				Section 17.5.   Using the Data Objects to Edit XML
				Section 17.6.   SQL Server 2000 XML
		Part II:   ADO.NET Core Classes
			Chapter 18.   The Connection Class
				Section 18.1.   Comments/Troubleshooting
				Section 18.2.   Properties Reference
				Section 18.3.   Methods Reference
				Section 18.4.   Events Reference
			Chapter 19.   The Command Class
				Section 19.1.   Comments/Troubleshooting
				Section 19.2.   Properties Reference
				Section 19.3.   Collections Reference
				Section 19.4.   Methods Reference
			Chapter 20.   The Parameter Class
				Section 20.1.   Comments/Troubleshooting
				Section 20.2.   Properties Reference
			Chapter 21.   The DataReader Class
				Section 21.1.   Comments/Troubleshooting
				Section 21.2.   Properties Reference
				Section 21.3.   Methods Reference
			Chapter 22.   The DataSet Class
				Section 22.1.   Comments/Troubleshooting
				Section 22.2.   Properties Reference
				Section 22.3.   Collections Reference
				Section 22.4.   Methods Reference
				Section 22.5.   Events Reference
			Chapter 23.   The DataTable Class
				Section 23.1.   Comments/Troubleshooting
				Section 23.2.   Properties Reference
				Section 23.3.   Collections Reference
				Section 23.4.   Methods Reference
				Section 23.5.   Events Reference
			Chapter 24.   The DataColumn Class
				Section 24.1.   Comments/Troubleshooting
				Section 24.2.   Properties Reference
				Section 24.3.   Collections Reference
			Chapter 25.   The DataRow Class
				Section 25.1.   Comments/Troubleshooting
				Section 25.2.   Properties Reference
				Section 25.3.   Collections Reference
				Section 25.4.   Methods Reference
			Chapter 26.   The Constraint Class
				Section 26.1.   Comments/Troubleshooting
				Section 26.2.   Properties Reference
				Section 26.3.   Collections Reference
			Chapter 27.   The DataRelation Class
				Section 27.1.   Comments/Troubleshooting
				Section 27.2.   Properties Reference
				Section 27.3.   Collections Reference
			Chapter 28.   The DataView Class
				Section 28.1.   Comments/Troubleshooting
				Section 28.2.   Properties Reference
				Section 28.3.   Methods Reference
				Section 28.4.   Events Reference
			Chapter 29.   The DataAdapter Class
				Section 29.1.   Comments/Troubleshooting
				Section 29.2.   Properties Reference
				Section 29.3.   Collections Reference
				Section 29.4.   Methods Reference
				Section 29.5.   Events Reference
			Chapter 30.   The CommandBuilder Class
				Section 30.1.   Comments/Troubleshooting
				Section 30.2.   Properties Reference
				Section 30.3.   Methods Reference
			Chapter 31.   The Transaction Class
				Section 31.1.   Comments/Troubleshooting
				Section 31.2.   Properties Reference
				Section 31.3.   Methods Reference
		Part III:   API Quick Reference
			Chapter 32.   How to Use This Quick Reference
				Section 32.1.   Finding a Quick-Reference Entry
				Section 32.2.   Reading a Quick-Reference Entry
			Chapter 33.   Converting from C# to VB Syntax
				Section 33.1.   General Considerations
				Section 33.2.   Classes
				Section 33.3.   Structures
				Section 33.4.   Interfaces
				Section 33.5.   Class, Structure, and Interface Members
				Section 33.6.   Delegates
				Section 33.7.   Enumerations
			Chapter 34.   The System.Data Namespace
				AcceptRejectRule
				CommandBehavior
				CommandType
				ConnectionState
				Constraint
				ConstraintCollection
				ConstraintException
				DataColumn
				DataColumnChangeEventArgs
				DataColumnChangeEventHandler
				DataColumnCollection
				DataException
				DataRelation
				DataRelationCollection
				DataRow
				DataRowAction
				DataRowChangeEventArgs
				DataRowChangeEventHandler
				DataRowCollection
				DataRowState
				DataRowVersion
				DataRowView
				DataSet
				DataSysDescriptionAttribute
				DataTable
				DataTableCollection
				DataView
				DataViewManager
				DataViewRowState
				DataViewSetting
				DataViewSettingCollection
				DBConcurrencyException
				DbType
				DeletedRowInaccessibleException
				DuplicateNameException
				EvaluateException
				FillErrorEventArgs
				FillErrorEventHandler
				ForeignKeyConstraint
				IColumnMapping
				IColumnMappingCollection
				IDataAdapter
				IDataParameter
				IDataParameterCollection
				IDataReader
				IDataRecord
				IDbCommand
				IDbConnection
				IDbDataAdapter
				IDbDataParameter
				IDbTransaction
				InRowChangingEventException
				InternalDataCollectionBase
				InvalidConstraintException
				InvalidExpressionException
				IsolationLevel
				ITableMapping
				ITableMappingCollection
				MappingType
				MergeFailedEventArgs
				MergeFailedEventHandler
				MissingMappingAction
				MissingPrimaryKeyException
				MissingSchemaAction
				NoNullAllowedException
				ParameterDirection
				PropertyAttributes
				PropertyCollection
				ReadOnlyException
				RowNotInTableException
				Rule
				SchemaType
				SqlDbType
				StateChangeEventArgs
				StateChangeEventHandler
				StatementType
				StrongTypingException
				SyntaxErrorException
				TypedDataSetGenerator
				TypedDataSetGeneratorException
				UniqueConstraint
				UpdateRowSource
				UpdateStatus
				VersionNotFoundException
				XmlReadMode
				XmlWriteMode
			Chapter 35.   The System.Data.Common Namespace
				DataAdapter
				DataColumnMapping
				DataColumnMappingCollection
				DataTableMapping
				DataTableMappingCollection
				DbDataAdapter
				DBDataPermission
				DBDataPermissionAttribute
				DbDataRecord
				DbEnumerator
				RowUpdatedEventArgs
				RowUpdatingEventArgs
			Chapter 36.   The System.Data.SqlClient Namespace
				SqlClientPermission
				SqlClientPermissionAttribute
				SqlCommand
				SqlCommandBuilder
				SqlConnection
				SqlDataAdapter
				SqlDataReader
				SqlError
				SqlErrorCollection
				SqlException
				SqlInfoMessageEventArgs
				SqlInfoMessageEventHandler
				SqlParameter
				SqlParameterCollection
				SqlRowUpdatedEventArgs
				SqlRowUpdatedEventHandler
				SqlRowUpdatingEventArgs
				SqlRowUpdatingEventHandler
				SqlTransaction
			Chapter 37.   The System.Data.OleDb Namespace
				OleDbCommand
				OleDbCommandBuilder
				OleDbConnection
				OleDbDataAdapter
				OleDbDataReader
				OleDbError
				OleDbErrorCollection
				OleDbException
				OleDbInfoMessageEventArgs
				OleDbInfoMessageEventHandler
				OleDbParameter
				OleDbParameterCollection
				OleDbPermission
				OleDbPermissionAttribute
				OleDbRowUpdatedEventArgs
				OleDbRowUpdatedEventHandler
				OleDbRowUpdatingEventArgs
				OleDbRowUpdatingEventHandler
				OleDbSchemaGuid
				OleDbTransaction
				OleDbType
			Chapter 38.   The System.Data.SqlTypes Namespace
				INullable
				SqlBinary
				SqlBoolean
				SqlByte
				SqlCompareOptions
				SqlDateTime
				SqlDecimal
				SqlDouble
				SqlGuid
				SqlInt16
				SqlInt32
				SqlInt64
				SqlMoney
				SqlNullValueException
				SqlSingle
				SqlString
				SqlTruncateException
				SqlTypeException
		Part IV:   Appendixes
			Appendix A.   ADO.NET Providers
				Section A.1.   The SQL Server Provider
				Section A.2.   The OLE DB Provider
				Section A.3.   The ODBC .NET Provider
				Section A.4.   The Oracle .NET Provider
				Section A.5.   The ODP.NET Provider
			Appendix B.   ADO.NET XML Extensions
				Section B.1.   codegen Namespace
				Section B.2.   msdata Namespace
				Section B.3.   diffgr Namespace
			Appendix C.   Microsoft Data Engine (MSDE)
				Section C.1.   Installing MSDE
				Section C.2.   MSDE Essentials
				Section C.3.   Adding the Northwind Data
				Section C.4.   Migrating MSDE to SQL Server
			Type, Method, Property, and Field Index
				A-L
				M-Z
		Colophon
		Index