Beginning C# 2008 Databases: From Novice to Professional

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.

Beginning C# 3.0 Databases is for every C# programmer. This book assumes no prior database experience, and teaches, always through hands-on examples, how to create and use relational databases with the standard database language SQL and how to access them with C#. Almost every application needs to access a database, and this book concisely teaches all the fundamentals needed—and most that are ever needed—to develop professional database applications.

Vidya Vrat Agarwal is a Microsoft .NET purist. He started working on Microsoft .NET with its 1st beta release. He has been involved in software development, evangelism, consultation, corporate training, and T3 programs on Microsoft .NET for various employers and corporate clients. Vidya is a published author for Apress titles Beginning C# 2008 Databases, Beginning VB 2008 Databases, and Pro ASP.NET 3.5 in VB 2008. He is also a technical reviewer of many books published by Apress.

Vidya works with Lionbridge Technologies (Nasdaq:LIOX) as a Technical Architect. He lives with his wife, Rupali, and daughter, Pearly. Vidya runs a Bellevue .NET User Group, www.BellevueDotNet.com, and blogs at http://dotnetpassion.blogspot.com.

James Huddleston has worked with computers since 1974, specializing in database design and development since 1980. He has a bachelor's degree in Latin and Greek from the University of Pennsylvania and a juris doctor degree from the University of Pittsburgh. A technical reviewer of dozens of computer books, including Beginning C# Objects: From Concepts to Code, he finds databases an endlessly fascinating area of work and almost as intellectually rewarding as his hobby: translating Homer's "Iliad" and "Odyssey" from the original Greek.

Ranga Raghuram has a bachelor's degree in engineering from Birla Institute of Technology and Science in Pilani, India, and a master's degree from Virginia Tech in Virginia.

Syed Fahad Gilani has more than 15 years of experience in computing. He sold his first program at the age of ten.

Jacob Hammer Pedersen started programming in the early 1990s, moving gradually from Pascal to C++ to Visual Basic. In the summer of 2000, he discovered C# and has explored it happily ever since.

Jon Reid was editor for the C++ and Object Query Language components of the Object Data Management Group standard, and has co-authored several C# books.