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® 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.