Beginning C# 2005 Databases: From Novice to Professional

Description

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

CONTENTS:

Getting our tools
Getting to know our tools
Introducing SQL
Introducing ADO.NET
Introducing connections
Introducing commands
Introducing data readers
Introducing datasets & data adapters
Introducing data binding
Understanding tables & relationships
Learning more about queries
Using stored procedures
Handling exceptions
Using transactions
Working with ADO.NET events
Working with text & binary data
Using XML
Introducing LINQ