Professional ADO.NET 2

ADO.NET revolutionized the way data was accessed through SQLServer, Oracle, and MySQL. With Microsoft's release of ADO.NET 2,ADO and the .NET Framework are integrated with SQL Server for thefirst time-enabling you to program .NET applications directlywithin the SQL Server database.Packed with sample code and recommended best practices for usingADO.NET 2, this code-intensive book explores the new data typesthat are available in the 2.0 Framework and discusses theappropriate time and way to use them. You'll learn how to makerepetitive, mundane tasks much simpler and you'll walk away with asolid foundation for developing database-driven applications.
What you will learn from this book
* The basics of creating a connection, executing a query, andreturning 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 variousways
* Why MySQL is a viable option for data storage
Who this book is for
This book is for experienced database developers who want tolearn the latest release of ADO.NET 2.0. Knowledge of ADO.NET 1.0,general .NET development, and Microsoft SQL Server isnecessary.
Wrox Professional guides are planned and written by workingprogrammers to meet the real-world needs of programmers,developers, and IT professionals. Focused and relevant, theyaddress the issues technology professionals face every day. Theyprovide examples, practical solutions, and expert education in newtechnologies, all designed to help programmers do a better job.

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