Synopses & Reviews
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 technologiesincluding the previous version of ADOso 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
- 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.
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.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 library, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.
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.
About the Author
Bill Hamilton is a technology and management consultant who specializes in assessing business objectives and company processes and designing and restructuring technology strategy and enterprise architecture. Bill has been designing, developing, and implementing enterprise solutions for 15 years using both Microsoft and J2EE technologies. Bill is the author of O'Reilly titles including the highly praised Programming SQL Server 2005 and ADO.NET Cookbook, and also writes for Microsoft Developer Network.
Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly).
Table of Contents
Preface; Audience; Contents of This Book; What's on the CD-ROM; Conventions Used in This Book; Comments and Questions; Acknowledgments; 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; ADO.NET Core Classes; Chapter 18: The Connection Class; 18.1 Comments/Troubleshooting; 18.2 Properties Reference; 18.3 Methods Reference; 18.4 Events Reference; Chapter 19: The Command Class; 19.1 Comments/Troubleshooting; 19.2 Properties Reference; 19.3 Collections Reference; 19.4 Methods Reference; Chapter 20: The Parameter Class; 20.1 Comments/Troubleshooting; 20.2 Properties Reference; Chapter 21: The DataReader Class; 21.1 Comments/Troubleshooting; 21.2 Properties Reference; 21.3 Methods Reference; Chapter 22: The DataSet Class; 22.1 Comments/Troubleshooting; 22.2 Properties Reference; 22.3 Collections Reference; 22.4 Methods Reference; 22.5 Events Reference; Chapter 23: The DataTable Class; 23.1 Comments/Troubleshooting; 23.2 Properties Reference; 23.3 Collections Reference; 23.4 Methods Reference; 23.5 Events Reference; Chapter 24: The DataColumn Class; 24.1 Comments/Troubleshooting; 24.2 Properties Reference; 24.3 Collections Reference; Chapter 25: The DataRow Class; 25.1 Comments/Troubleshooting; 25.2 Properties Reference; 25.3 Collections Reference; 25.4 Methods Reference; Chapter 26: The Constraint Class; 26.1 Comments/Troubleshooting; 26.2 Properties Reference; 26.3 Collections Reference; Chapter 27: The DataRelation Class; 27.1 Comments/Troubleshooting; 27.2 Properties Reference; 27.3 Collections Reference; Chapter 28: The DataView Class; 28.1 Comments/Troubleshooting; 28.2 Properties Reference; 28.3 Methods Reference; 28.4 Events Reference; Chapter 29: The DataAdapter Class; 29.1 Comments/Troubleshooting; 29.2 Properties Reference; 29.3 Collections Reference; 29.4 Methods Reference; 29.5 Events Reference; Chapter 30: The CommandBuilder Class; 30.1 Comments/Troubleshooting; 30.2 Properties Reference; 30.3 Methods Reference; Chapter 31: The Transaction Class; 31.1 Comments/Troubleshooting; 31.2 Properties Reference; 31.3 Methods Reference; 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; Chapter 35: The System.Data.Common Namespace; Chapter 36: The System.Data.SqlClient Namespace; Chapter 37: The System.Data.OleDb Namespace; Chapter 38: The System.Data.SqlTypes Namespace; Appendixes; ADO.NET Providers; The SQL Server Provider; The OLE DB Provider; The ODBC .NET Provider; The Oracle .NET Provider; The ODP.NET Provider; ADO.NET XML Extensions; codegen Namespace; msdata Namespace; diffgr Namespace; Microsoft Data Engine (MSDE); Installing MSDE; MSDE Essentials; Adding the Northwind Data; Migrating MSDE to SQL Server; Colophon;