Regardless of your level of experience with database programming, you will gain insight into the world of .NET by reading Mastering Visual Basic.NET Database Programming. This book is a hands-on guide that provides you with both the architecture and code for writing applications that work with SQL Server 2000 systems. You will learn best practices at constructing a distributed system using VB.NET.

This book will help you understand the .NET database technologies and show you how they all fit together in a way that will enable you to architect .NET WebServices, Windows, and ASP.NET applications. There are also many satellite technologies that surround database systems. This book delves into working with all these languages and tools, such as XSL Transformations, XPath Queries, accessing SQL Server 2000 using HTTP and XML, the VS .NET XML Designer, ADO.NET and the .NET data providers. By taking an around-the-world tour of all these technologies, you will better be able to design your systems to take full advantage of the leading-edge technologies and tools. The information provided in this book will enable you to reduce the cost of delivery and increase your productivity using the .NET Framework.

The explanations provided in this book are very crisp and concise. You’ll get a clear understanding of how to build your own VB.NET database systems by following step-by-step walkthroughs or loading the actual Visual Studio .NET solutions from the accompanying CD.



Visual Basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic .NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes:

• Getting familiar with the ADO.NET object model
• Using the data access wizards
• Taking advantage of new SQL Server 2000 features
• Carrying out XSL Transformations and XPath queries
• Generating XML using the T-SQL FOR XML statement
• Binding controls to ADO.NET result sets
• Arriving at a sound database design
• Tuning your SQL Server 2000 database
• Using the XML Designer in Visual Studio .NET
• Leveraging the data access tools available in the Visual Studio .NET IDE
• Working with .NET data providers
• Choosing between streaming data and caching data
• Working with the Data Form Wizard in Visual Studio .NET
• Using advanced ADO.NET techniques
• Building a threaded application
• Using .NET's advanced exception handling capabilities
• Using the .NET Deployment Project Template

Source: Mastering VB.NET Database Programming