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...
Search in google:
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 bookThe basics of creating a connection, executing a query, and returning a resultBest uses for Oracle in the ADO.NET FrameworkThe many new features that are available for XMLHow to use the full text search capabilities of Microsoft® SQL Server 2005Methods for retrieving data and presenting it in various waysWhy MySQL is a viable option for data storageWho this book is forThis 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.
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.
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
