Beginning C# 2005 Databases: From Novice to Professional teaches you everything you need to know about relational databases, the SQL database language, and ADO.NET 2.0. You'll also get a sound start in developing console, Windows Forms, ASP.NET, and even XML database applications.
This book also teaches you database basics and how to use SQL to communicate with databases. You'll get detailed and code-practical techniques to access data in C# across a wide range of specific coding situations. Fully revised and upgraded for .NET 2.0, this book offers you the best contemporary practice in this core programming area, and you'll find yourself using it in nearly all of your .NET projects. This book systematically:
Provides step-by-step instructions on installing and configuring Visual C# and SQL Server Express editions
Presents all essential SQL query and update concepts and syntax, so you dont need prior familiarity with relational databases or SQL
Describes how to use ADO.NET transactions, exceptions, and events
Covers ADO.NET features for handling XML, text, and binary data
Explains all concepts through straightforward code examples