Book description
Written by experts on the Microsoft® .NET programming platform, ADO.NET in a Nutshell delivers everything .NET programmers will need to get a jump-start on ADO.NET technology or to sharpen their skills even further. In the tradition of O'Reilly's In a Nutshell Series, ADO.NET in a Nutshell is the most complete and concise source of ADO.NET information available.ADO.NET is the suite of data access technologies in the .NET Framework that developers use to build applications services accessing relational data and XML. Connecting to databases is a fundamental part of most applications, whether they are web, Windows®, distributed, client/server, XML Web Services, or something entirely different. But ADO.NET is substantially different from Microsoft's previous data access technologies--including the previous version of ADO--so even experienced developers need to understand the basics of the new disconnected model before they start programming with it.Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately.Topics covered in the book include:
- An Introduction to ADO.NET
- Connections, Commands and DataReaders
- Disconnected Data
- Advanced DataSets
- Transactions
- DataViews and Data Binding
- XML and the DataSet
Publisher resources
Table of contents
- A Note Regarding Supplemental Files
- Preface
-
I. ADO.NET Tutorial
- 1. Introduction
- 2. .NET Data Providers
- 3. Connections
- 4. Commands
- 5. DataReaders
- 6. DataSets
-
7. DataTables
- Creating a DataTable
- Working with Columns
- Constraints
- Primary Key
- Rows
- Loading Data
- Committing and Discarding Changes
- Cloning the Schema of the Table
- Copying the Table
- Selecting a Subset of Rows
- Performing Aggregate Calculations
- Removing All Data
- Resetting the Table
- Identifying Errors in the Table
- DataTable Events
- 8. DataColumns
- 9. DataRows
- 10. Constraints
- 11. DataRelations
- 12. DataViews and Data Binding
- 13. Strongly Typed DataSets
- 14. DataAdapters
- 15. Updating the Data Source
- 16. Transactions
- 17. XML and the DataSet
-
II. ADO.NET Core Classes
- 18. The Connection Class
- 19. The Command Class
- 20. The Parameter Class
- 21. The DataReader Class
- 22. The DataSet Class
- 23. The DataTable Class
- 24. The DataColumn Class
- 25. The DataRow Class
- 26. The Constraint Class
- 27. The DataRelation Class
- 28. The DataView Class
- 29. The DataAdapter Class
- 30. The CommandBuilder Class
- 31. The Transaction Class
-
III. API Quick Reference
- 32. How to Use This Quick Reference
- 33. Converting from C# to VB Syntax
-
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
- 35. The System.Data.Common Namespace
-
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
-
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
- 38. The System.Data.SqlTypes Namespace
- IV. Appendixes
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: ADO.NET in a Nutshell
- Author(s):
- Release date: April 2003
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596003616
You might also like
book
ADO.NET Cookbook
Designed in the highly regarded O'Reilly Cookbook format, ADO.NET Cookbook is strikingly different from other books …
book
Microsoft® ADO.NET 4 Step by Step
Teach yourself the fundamentals of ADO.NET 4 -- one step at a time. With this practical, …
book
Pro ODP .NET for Oracle Database 11g
This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version …
book
ADO.NET 3.5 Cookbook, 2nd Edition
This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down …