ADO.NET in a Nutshell

Larger Cover

By Bill Hamilton, Matthew MacDonald

Publisher: O'Reilly Media

Released: April 2003

Pages: 624

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

Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell series, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.

ADO.NET Tutorial
1. Chapter 1 Introduction
  1. ADO.NET Data Providers
  2. Connected and Disconnected Data
2. Chapter 2 .NET Data Providers
  1. Data Providers
  2. Selecting a Data Provider
  3. Creating a Custom Data Provider
3. Chapter 3 Connections
  1. Connection Object Overview
  2. The Connection String
  3. Opening and Closing Connections
  4. Connection Pooling
4. Chapter 4 Commands
  1. Command Object Overview
  2. Creating and Executing a Command
  3. Parameter Object Overview
  4. Parameterized Commands
  5. Commands with Stored Procedures
  6. Commands and Data Definition Language (DDL)
5. Chapter 5 DataReaders
  1. DataReader Object Overview
  2. Performing a Query with a DataReader
  3. Stored Procedures with the DataReader
  4. DataReaders and Schema Information
6. Chapter 6 DataSets
  1. Creating an Untyped DataSet
  2. Working with Tables in the DataSet
  3. Adding and Removing Relations
  4. Adding Custom Information
  5. Cloning the Schema
  6. Copying the DataSet
  7. Merging Two DataSets
  8. Removing All Data
  9. Resetting the DataSet
  10. Committing and Discarding Changes
7. Chapter 7 DataTables
  1. Creating a DataTable
  2. Working with Columns
  3. Constraints
  4. Primary Key
  5. Rows
  6. Loading Data
  7. Committing and Discarding Changes
  8. Cloning the Schema of the Table
  9. Copying the Table
  10. Selecting a Subset of Rows
  11. Performing Aggregate Calculations
  12. Removing All Data
  13. Resetting the Table
  14. Identifying Errors in the Table
  15. DataTable Events
8. Chapter 8 DataColumns
  1. Creating DataColumns
  2. Creating AutoIncrement Columns
  3. Creating Expression Columns
  4. Handling Null Values
  5. Mapping .NET Data Provider Types to .NET Framework Types
9. Chapter 9 DataRows
  1. Creating a DataRow
  2. Updating Rows
  3. Deleting Rows
  4. Using Row State Information
  5. Using Row Version Information
  6. Accepting or Rejecting Changes to Rows
  7. Navigating Parent and Child Rows
  8. Using Row Error Information
10. Chapter 10 Constraints
  1. Constraint Object Overview
  2. The UniqueConstraint
  3. The ForeignKeyConstraint
11. Chapter 11 DataRelations
  1. DataRelation Object Overview
  2. Navigating Relational Data
12. Chapter 12 DataViews and Data Binding
  1. The DataView and DataViewManager
  2. Sorting and Filtering
  3. Accessing Data Through a DataView
  4. Windows Data Binding
  5. ASP.NET Data Binding
13. Chapter 13 Strongly Typed DataSets
  1. Creating a Strongly Typed DataSet
  2. Adding a Row
  3. Editing a Row
  4. Finding a Row
  5. Null Data
  6. Navigating Hierarchical Data
  7. Annotations
14. Chapter 14 DataAdapters
  1. Creating DataAdapter Object
  2. Retrieving Data from the Data Source
  3. Retrieving Schema Information from the Data Source
  4. Updating the Data Source
  5. Mapping Tables and Columns
  6. AcceptChangesDuringFill
  7. ContinueUpdateOnError
  8. DataAdapter Events
15. Chapter 15 Updating the Data Source
  1. SqlCommandBuilder Class Overview
  2. Updating a Data Source Using Command Builder
  3. Updating a Data Source Using Custom Logic
  4. Refreshing Data After Updating
  5. Retrieving Updated Values from the Data Source
  6. Updating Data in Related Tables
  7. Handling Concurrency Issues
  8. Optimization
16. Chapter 16 Transactions
  1. Manual Transactions
  2. Isolation Levels
  3. Savepoints
  4. Nested Transactions
  5. Transactions Using a DataAdapter
  6. Automatic Transactions
17. Chapter 17 XML and the DataSet
  1. DataSet XML Methods
  2. Shaping DataSet XML
  3. Other .NET XML Classes
  4. XmlDataDocument Object Overview
  5. Using the Data Objects to Edit XML
  6. SQL Server 2000 XML
ADO.NET Core Classes
1. Chapter 18 The Connection Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Methods Reference
  4. Events Reference
2. Chapter 19 The Command Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
  4. Methods Reference
3. Chapter 20 The Parameter Class
  1. Comments/Troubleshooting
  2. Properties Reference
4. Chapter 21 The DataReader Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Methods Reference
5. Chapter 22 The DataSet Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
  4. Methods Reference
  5. Events Reference
6. Chapter 23 The DataTable Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
  4. Methods Reference
  5. Events Reference
7. Chapter 24 The DataColumn Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
8. Chapter 25 The DataRow Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
  4. Methods Reference
9. Chapter 26 The Constraint Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
10. Chapter 27 The DataRelation Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
11. Chapter 28 The DataView Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Methods Reference
  4. Events Reference
12. Chapter 29 The DataAdapter Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Collections Reference
  4. Methods Reference
  5. Events Reference
13. Chapter 30 The CommandBuilder Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Methods Reference
14. Chapter 31 The Transaction Class
  1. Comments/Troubleshooting
  2. Properties Reference
  3. Methods Reference
API Quick Reference
1. Chapter 32 How to Use This Quick Reference
  1. Finding a Quick-Reference Entry
  2. Reading a Quick-Reference Entry
2. Chapter 33 Converting from C# to VB Syntax
  1. General Considerations
  2. Classes
  3. Structures
  4. Interfaces
  5. Class, Structure, and Interface Members
  6. Delegates
  7. Enumerations
3. Chapter 34 The System.Data Namespace
4. Chapter 35 The System.Data.Common Namespace
5. Chapter 36 The System.Data.SqlClient Namespace
6. Chapter 37 The System.Data.OleDb Namespace
7. Chapter 38 The System.Data.SqlTypes Namespace
Appendixes
1. Appendix ADO.NET Providers
  1. The SQL Server Provider
  2. The OLE DB Provider
  3. The ODBC .NET Provider
  4. The Oracle .NET Provider
  5. The ODP.NET Provider
2. Appendix ADO.NET XML Extensions
  1. codegen Namespace
  2. msdata Namespace
  3. diffgr Namespace
3. Appendix Microsoft Data Engine (MSDE)
  1. Installing MSDE
  2. MSDE Essentials
  3. Adding the Northwind Data
  4. Migrating MSDE to SQL Server

Colophon

Title:

ADO.NET in a Nutshell

By:

Bill Hamilton, Matthew MacDonald

Publisher:

O'Reilly Media

Formats:

Print
Safari Books Online

Print:

April 2003

Pages:

624

Print ISBN:

978-0-596-00361-6

| ISBN 10:

0-596-00361-7

Bill Hamilton

Bill Hamilton is a software architect specializing in designing, developing and implementing distributed applications using .NET and J2EE technologies. Over the last ten years, he has provided consulting services in B2B, B2C, B2E, data integration, and portal initiatives for banking, retail, accounting, manufacturing, and financial services. An early technology adopter, he frequently evaluates, recommends, and helps his clients use new technologies effectively. Bill has designed and helped build several award winning software packages. Bill is the co-author of O'Reilly's ADO.NET in a Nutshell and author of ADO.NET Cookbook.

View Bill Hamilton's full profile page.
Matthew MacDonald

is President of ProseTech, a software documentation consultancy, and a project manager at VoiceIQ (http://www.voiceiq.com/), a provider of software for interactive voice-enabled applications and services. Matthew is a coauthor of the ASP.NET in a Nutshell (O'Reilly), and a contributor to the C# in a Nutshell (O'Reilly) API reference.

View Matthew MacDonald's full profile page.

Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animal on the cover of ADO.NET in a Nutshell is an African spoonbill (Platalea alba). The African spoonbill a long-legged wading bird distinguished by a bare red face and legs, all-white plumage, and a long spatulate bill, the inside ofwhich reacts to touch, causing the bill to snap shut on its prey. It feeds by fishing in shallow water, swinging its open bill from side to side.

The African spoonbill's habitat includes the lakes, marshes, rivers, and estuaries of southern Africa. A shyand alert bird, it's usuallyfound singlybut can also be encountered in pairs or in groups. It is usuallysilent except for an occasional grunt when alarmed. It flies with its neck and legs extended, flapping its wings steadily in the air.

At birth, this bird's beak is short; it graduallydevelops into its spoon-like shape. Following a spring courtship, eggs are laid in a nest platform of sticks or reeds in a tree near water; however, nests can also be found in swamp reeds, among rocks, marsh plants, or on cliffs. Males and females share incubation and feeding the young for about 20 to 30 days. Young birds begin to fly after another four weeks. Mary Anne Weeks Mayo was the production editor and copyeditor for ADO.NET in a Nutshell. Ann Schirmer proofread the book. Matt Hutchinson and Claire Cloutier provided qualitycontrol. Reg Aubry, Sue Willing, Genevieve d'Entremont, and Judy Hoer provided production assistance. Brenda Miller wrote the index.

Emma Colbydesigned the cover of this book, based on a series design by Edie Freedman. The cover image is an illustration from the 1898 edition of Animate Creation Illustrated. Bret Kerr produced the cover layout with QuarkXPress 4.1 using Adobe's ITC Garamond font. David Futato designed and produced the CD label with QuarkXPress 4.1 using Adobe's ITC Garamond font.

Bret Kerr designed the interior layout, based on a series design by David Futato. This book was converted byMike Sierra to FrameMaker 5.5.6 with a format conversion tool created byErik Ray, Jason McIntosh, Neil Walls, and Mike Sierra that uses Perl and XML technologies. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont's TheSans Mono Condensed. The illustrations that appear in the book were produced by Robert Romano and Jessamyn Read using Macromedia FreeHand 9 and Adobe Photoshop 6. The tip and warning icons were drawn by Christopher Bing. This colophon was compiled by Mary Anne Weeks Mayo.

Description

Table of Contents

Product Details

About the Author

Colophon