Book Review: Database Programming with C#
page 1 of 1
Published: 03 Nov 2003
Unedited - Community Contributed
Abstract
A book review of "Database Programming with C#" by Carsten Thomsen. Published by Apress (2002)
by Steve Sharrock
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 18115/ 22

In these days when all publishers rush to press with their 800+ page offerings on the new .NET technology, it is quite refreshing to find an author that truly knows the subject matter, and knows how to communicate the information without simply rewriting the online product documentation. While reading this book I had the feeling that the author, like me, made his living doing database programming with C#.

The author, Carsten Thomsen, says that this offering is based on his earlier book Database Programming with VB.NET. It seems clear that both his prior experience in writing about this topic, and his prior experience with database programming in general have been combined to produce not only a great tutorial, but also a good reference.

Database Programming With C#
cover

 

Table of Contents

Part One - Getting Started

  • A Lightning-Quick Introduction to C#

Part Two - Database Programming

  • Using Databases
  • Presenting ADO.NET: The Connected Layer
  • Presenting ADO.NET: The Disconnected Layer
  • Presenting the IDE from a Database Viewpoint
  • Exception Handling
  • Using Stored Procedures, Views, and Triggers
  • Hierarchical Databases
  • Message Queues
  • Data Wrappers
  • Data-Bound Controls

Part Three - Example Applications

  • UserMan

Appendix A

  • Using XML with SQL Server 2000

Highlights

Although this book is written for the intermediate level programmer and above, there is certainly no reason a beginner can't absorb much of this information. There is a good, brief review of C# and Visual Studio basics. The introductory information also covers many relational database basics and includes a great, succinct review of normalization.

The examples throughout the book all show good C# programming practices. In both the introductory information and also throughout the examples, the author explains the differences between different connections including OleDb, Sql and Odbc.

Specific examples are provided for the following:

  • MySQL 3.23.45 or later
  • Oracle 8i or later
  • Microsoft Access 2000 or later
  • SQL Server.
  • XML with SQL Server 2000

All of the examples seem to appear free of errors or other problems found in some of the "rush-to-press" books I've reviewed.

The more advanced topics, such as exception handling and using delegates to handle events is very well explained with easy to understand examples.

Summary

Thanks, Carsten. Database Programming with C# gets a very high recommendation.

 

Steve Sharrock -   www.AspAlliance.com/shark / www.SharkCode.com



User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-04-25 8:14:39 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search