Beginning C# 2005 Databases (Programmer to Programmer) (Paperback)

by Karli Watson (Author)
Key Phrases: typed data sets, optimistic concurrency management, data reader objects, Database Explorer, Server Management Studio Express, Cancel Figure (more...)

Editorial Reviews

Product Description

• Providing beginners with the basics of databases, database design, and SQL programming, this book shows novice programmers how to use C# and ADO.NET to manipulate data in databases
• Includes hands-on examples, helpful tips, and real-world scenarios on accessing data from Windows applications, ASP.NET applications, and Web Services
• The SQL provider for accessing SQL Server databases, ADO.NET, and the new .NET 2.0 features
• Covers the fundamentals of accessing and manipulating data while giving a solid understanding of relational database design
• Topics covered include modifying data, custom data binding, working with disconnected data, and much more

From the Back Cover
Offering readers the solid fundamentals of database concepts and data manipulation with C#, this book explains database management system (DBMS) types and features and covers SQL, ASP.NET applications, web services, and transaction management techniques, including how to deal with concurrency issues.

Serving as an ideal teaching tool on building database applications using C#, the book also looks at both visual techniques and data binding and programmatic data access. Real-world examples, new database techniques, and try-it-out exercises all contribute to helping you put your reading about database applications into practice.

What you will learn from this book

• How to use queries, views, and stored procedures to access and manipulate data from your applications
• How to use custom data access code to implement an n-tier design for your applications
• Ways to work with disconnected data
• How to write functions and stored procedures in C#
• How to use Microsoft® SQL Server 2005 Express and other free Express products, which are all you need for this book

Who this book is for

This book is for beginning C# 2005 developers who already have some experience with C# 2005 developing Windows® and ASP.NET applications.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

See all Editorial Reviews

Product Details

• Paperback: 528 pages
• Publisher: Wrox (October 16, 2006)
• Language: English
• ISBN-10: 0470044063
• ISBN-13: 978-0470044063
• Product Dimensions: 9 x 7.4 x 1.3 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.7 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #470,884 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

7 of 8 people found the following review helpful:

5.0 out of 5 stars An Excellent Intermediate Level Book, November 21, 2006

By	John Matlock "Gunny" (Winnemucca, NV) - See all my reviews (REAL NAME)

C# (Pronounced C Sharp) is Microsoft's version of C++ that has modified and extended to fit into it's .NET 2.0 operating environment. One of the major advancements in C# is in its ability to interact with databases. It uses SQL to do the actual database manipulation.

I rank this book as intermediate in nature. As a prerequisite I recommend two other subjects for the beginner. One would be on SQL, and particularly T-SQL, the particular dialect spoken by Microsoft SQL Server. And second a book on programming C# in Visual Studio. This is an integrated development environment that has a lot of features that will be of help in writing C# programs.

While this book does have a section called 'A SQL Primer,' it is just that, a primer. There are a lot of situations where a task can be programmed either in C# or SQL. An example would be to extract some data from the database and depending on its value extract nothing else, or go get some additional data. This will work faster if it is done in SQL rather than C#. The SQL IF statement isn't covered in this book.

The strength of this book is in tying together C# and SQL especially when combined with ASP.NET applications to produce dynamic web pages. At that, it is excellent.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Best book on C# databases for SQL to date, October 6, 2007

By	A_2007_reader (Vladivostok, Russia) - See all my reviews

If you read my other reviews you know I don't give five stars to books I've read, but I do here only because as of right now (October 2007), and using the Visual Studio 2005 with ADO.NET 2.0, this is the only book that will give you a step-by-step How To walkthrough on all aspects of SQL Server. It also has a chapter on ASP.NET. As for now, it's indespensible for me, learning this topic. A couple of years from now it might be trash, but that's the nature of computer books. I'm about 1/3rd of the way through the book and no serious errors have been found, just a few things you can fix or figure out yourself. The downloadable code works for the above environment.

3 of 4 people found the following review helpful:

4.0 out of 5 stars Excellent to begin with, August 14, 2007

By	Elias Bachaalany (Beirut, Lebanon) - See all my reviews (REAL NAME)

I was looking for a begining to start database programming in C# and VS2005 and I took my chances with this book.

I have to admit that it really helped me alot to get started, here are the points I found useful:

1. You will definitely learn about ADO.NET basics and concepts and differences between adapters, datasets, tables and other classes.
2. The book shows step by step instructions on how to get apply what you are learning
3. The books gives theory, applications and hints so that all your questions are answered in each chapter
4. Comes with a real life scenario database "FolksTale" that you will learn how to program. The tales are nice by the way! :)

To get started you need some knowledge in SQL and basic C#/Windows forms skills.

The downside of this book is that some chapters talk alot about Web applications and how to use them with databases.
Although this can be a plus, but if have no Web programming experience you might feel frustrated and obliged to skip two chapters.

I highly recommend this book!