Mastering C# Database Programming

Enter a New World of Database Programming

C# and ADO.NET facilitate the development of a new generation of database applications, including remote applications that run on the Web. Mastering C# 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:

• Accessing a database using C# and ADO.NET
• Using SQL to access a database
• Using Visual Studio .NET to build applications
• Creating and modifying database tables
• Understanding ADO.NET classes
• Designing, building, and deploying Web applications that access a database
• Designing, building, and deploying effective Web services
• Using SQL Server's built-in XML capabilities
• Working with a database in a disconnected manner
• Using advanced transaction controls
• Using Transact-SQL to create stored procedures and functions in a SQL Server database

Contents

Introduction

Part 1 • Introduction to ADO.NET and Databases
  Chapter 1 • Introduction to Database Programming with ADO.NET
  Chapter 2 • Introduction to Databases
  Chapter 3 • Introduction to Structured Query Language (SQL)
  Chapter 4 • Introduction to Transact-SQL Programming
  Chapter 5 • Overview of the ADO.NET Classes
  Chapter 6 • Introducing Windows Applications and ADO.NET

Part 2 • Fundamental Database Programming with ADO.NET
  Chapter 7 • Connecting to a Database
  Chapter 8 • Executing Database Commands
  Chapter 9 • Using DataReader Objects to Read Results
  Chapter 10 • Using DataSet Objects to Store Data
  Chapter 11 • Using DataSet Objects to Modify Data
  Chapter 12 • Navigating and Modifying Related Data
  Chapter 13 • Using DataView Objects

Part 3 • Advanced Database Programming with ADO.NET
  Chapter 14 • Advanced Transaction Control
  Chapter 15 • Introducing Web Applications—ASP.NET
  Chapter 16 • Using SQL Server's XML Support
  Chapter 17 • Web Services

Index