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