|
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 is this book 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
|
