ADO.NET in a Nutshell

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.

Table of Contents

Part I. Ado.Net Tutorial
Chapter 1. Introduction
Chapter 2. .Net Data Providers
Chapter 3. Connections
Chapter 4. Commands
Chapter 5. Datareaders
Chapter 6. Datasets
Chapter 7. Datatables
Chapter 8. Datacolumns
Chapter 9. Datarows
Chapter 10. Constraints
Chapter 11. Datarelations
Chapter 12. Dataviews And Data Binding
Chapter 13. Strongly Typed Datasets
Chapter 14. Dataadapters
Chapter 15. Updating The Data Source
Chapter 16. Transactions
Chapter 17. Xml And The Dataset

Part II. Ado.Net Core Classes
Chapter 18. The Connection Class
Chapter 19. The Command Class
Chapter 20. The Parameter Class
Chapter 21. The Datareader Class
Chapter 22. The Dataset Class
Chapter 23. The Datatable Class
Chapter 24. The Datacolumn Class
Chapter 25. The Datarow Class
Chapter 26. The Constraint Class
Chapter 27. The Datarelation Class
Chapter 28. The Dataview Class
Chapter 29. The Dataadapter Class
Chapter 30. The Commandbuilder Class
Chapter 31. The Transaction Class

Part III. Api Quick Reference
Chapter 32. How To Use This Quick Reference
Chapter 33. Converting From C# To Vb Syntax
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

Part IV. Appendixes
Chapter A. Ado.Net Providers
Chapter B. Ado.Net Xml Extensions
Chapter C. Microsoft Data Engine (Msde)