Beginning C# 2005 Databases (Programmer to Programmer)

Providing beginners with the basics of databases, database design, and SQL programming, this book shows novice programmers how to use C# and ADO.NET to manipulate data in databases Includes hands-on examples, helpful tips, and real-world scenarios on accessing data from Windows applications, ASP.NET applications, and Web Services The SQL provider for accessing SQL Server databases, ADO.NET, and the new .NET 2.0 features Covers the fundamentals of accessing and manipulating data while giving a solid understanding of relational database design Topics covered include modifying data, custom data binding, working with disconnected data, and much more Beginning C# 2005 Databases 1 Contents 16 Introduction 22 Chapter 1: Database Fundamentals 28 Chapter 2: Databases and C# 62 Chapter 3: Viewing Data 96 Chapter 4: Modifying Data 140 Chapter 5: Databases and the Internet 176 Chapter 6: Accessing Databases Programmatically 220 Chapter 7: Views and Stored Procedures 268 Chapter 8: Custom Data Objects 318 Chapter 9: Transactions and Concurrency 362 Chapter 10: Working with Disconnected Data 402 Chapter 11: SQL Server CLR Integration 444 Appendix A: Installation 484 Appendix B: Database Installation 494 Appendix C: Answers to Exercises 500 Index 510 Provides information on database applications using C#, covering such topics as SQL, ASP.NET applications, Web services, and concurrency.