Beginning C# 2008 Databases: From Novice to Professional

Description

Assuming only basic knowledge of C# 2008, Beginning C# 2008 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers.

A comprehensive tutorial on both SQL Server 2005 and ADO.NET 3.0, Beginning C# 2008 Databases explains and demonstrates how to create database objects and program against them in both T-SQL and C#. Full of practical, detailed examples, it's been fully revised and updated for C# 2008 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.

* Comprehensively and concisely explains fundamental database concepts and programming techniques
* Rich in working examples of both T-SQL and C# programs
* Covers all the features most database programming ever requires What you'll learn
* How relational databases work and how to use them
* How C# uses ADO.NET to access databases
* How to write stored procedures in T-SQL and call them from C# programs
* How to use XML in database applications
* How to use LINQ to simplify C# database programming
* How to install SQL Server 2005 Express and Visual C# 3.0
* Express and use them to teach yourself database programming by doing it Who this book is for

Beginning C# 2008 Databases is for every C# programmer. Database programming requires relatively little knowledge of C# but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience and teaches you, always through hands-on examples, how to create and use relational databases with SQL and how to access them with C#. Almost every application needs to access a database, and this book teaches all the fundamentals you needand may ever needto develop professional database applications.

CONTENTS:

Getting Your tools

Getting to know your tools

Getting to know relational databases

Writing database queries

Manipulating Database data

Using stored Procedures

Using XML

Understanding transactions

Getting to know ADO.NET

Making connections

Executing Commands

Using Data readers

Using Datasets and Data Adapters

Building windows forms applications

Building ASP.NET Applications

Handling Exceptions

Working with Events

Working with Text and Binary Data

Using LINQ

Using ADO.NET 3.5

Index