Professional ADO.NET with VB.NET

ADO.NET is Microsoft's latest data access technology and, as an integral part of the .NET Framework, is far more than just an ADO upgrade. ADO.NET provides an extensive set of .NET classes that facilitate efficient access to data in a large variety of sources, enable sophisticated manipulation and sorting of data, and form an important framework within which to implement inter-application communication.

This book provides a comprehensive guide to using ADO.NET, with plenty of practical code examples and extensive technical information. Whether you're developing web applications using ASP.NET, Windows Forms applications, or XML Web Services, this book will show you how to use .NET's data access technology to maximum effect. Along the way, it looks at:

• Understanding the architecture of the ADO.NET data providers
• Reading and writing data with data readers, data adapters and DataSets
• Making development safer with XML Schemas and strongly typed DataSets
• Defining constraints on and relationships between your data
• Using ADO.NET's built-in support for transactional processing
• Optimizing the performance and security of your ADO.NET applications
• Developing your own data provider for a custom data source
• Who is This Book For?
  If you're already developing applications within the .NET Framework, or you have experience of developing data-driven applications with ADO and wish to make the transition to .NET, then this book is for you. It is aimed at fairly experienced programmers, and is not intended for the hobbyist or the beginner.

Contents

• An Overview of ADO.NET
• Using Data Readers
• DataSets
• Using Data Adapters
• Typed Datasets and Dataset Schemas
• XML and the DataSet
• Constraints, Relations, and Views
• Transactions
• Mapping
• Making a Data Services Component
• ADO.NET and Web Services
• SQL Server Native XML Support
• Performance and Security
• Integration and Migration
• Creating a Custom .NET Data Provider
• Appendix: Visual Studio .NET and ADO.NET