Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL

ADO.NET revolutionized the way data was accessed through SQL Server, Oracle, and MySQL. With Microsoft's release of ADO.NET 2, ADO and the .NET Framework are integrated with SQL Server for the first time-enabling you to program .NET applications directly within the SQL Server database.

Packed with sample code and recommended best practices for using ADO.NET 2, this code-intensive book explores the new data types that are available in the 2.0 Framework and discusses the appropriate time and way to use them. You'll learn how to make repetitive, mundane tasks much simpler and you'll walk away with a solid foundation for developing database-driven applications.

What you will learn from this book

• The basics of creating a connection, executing a query, and returning a result
• Best uses for Oracle in the ADO.NET Framework
• The many new features that are available for XML
• How to use the full text search capabilities of Microsoft(r) SQL Server 2005
• Methods for retrieving data and presenting it in various ways
• Why MySQL is a viable option for data storage

Who this book is for

This book is for experienced database developers who want to learn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0, general .NET development, and Microsoft SQL Server is necessary.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Table of Contents

Acknowledgments.

Contents.

Introduction.

What This Book Is About.

Who Should Buy This Book.

How to Use This Book.

What This Book Covers.

Providing Feedback.

Chapter 1: History of Data Access.

Chapter 2: Standardized Database Objects and Design.

Chapter 3: ADO.NET Essentials.

Chapter 4: Standard Data Types.

Chapter 5: ADO.NET Integration with XML.

Chapter 6: Transactions.

Chapter 7: Data Binding.

Chapter 8: Building a Custom ADO.NET Data Provider.

Chapter 9: T-SQL Language and Enhancements.

Chapter 10: ADO.NET Programming with SQL Server from a Client Application.

Chapter 11: SQL Server 2005 Server-Side Programming.

Chapter 12: Notification Services.

Chapter 13: Service Broker.

Chapter 14: Full-Text Searching.

Chapter 15: Reporting.

Chapter 16: ADO.NET 2 and Open-Source Databases.

Chapter 17: Oracle and ADO.NET.

Appendix A: Constants/Enums in ADO.NET.

Index.