VB.NET & SQL Server 2000: Building an Effective Data Layer [Illustrated] [Paperback]

Tony Bain (Author), Denise Gosnell (Author), Jonathan A. Walsh (Author)

Book Description

Series: Programmer to Programmer | Publication Date: June 2002

Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft's .NET Framework brings us ADO.NET, the latest means of connecting to that data source.

This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate SQL Server 2000 with VB .NET applications using ADO.NET.

ADO.NET introduces .NET classes for:

- Efficient access to multiple data sources
- Data sorting
- Data manipulation
- Improved inter-application communication

"Building an effective data layer" illustrates how to take advantage of the new features available in the .NET Framework when working with data-centric applications. It covers:

- The key classes and objects in ADO.NET and how to utilize them to access and manipulate data from SQL Server 2000
- How to write and utilize efficient stored procedures, to reduce middle-tier code
- Databinding methods for use in both Windows Forms and Web Form applications
- Transactions and locking management
- Transactions and object pooling

Editorial Reviews

From the Publisher

If you are an experienced VB developer, capable of writing complex applications and comfortable with the use of T-SQL and stored procedures to manage data in SQL Server (version 7 or above), then this book will provide the practical knowledge you need to develop effective .NET data-centric applications.

Product Details

• Paperback: 564 pages
• Publisher: Peer Information; 1st edition (June 2002)
• Language: English
• ISBN-10: 1861007051
• ISBN-13: 978-1861007056
• Product Dimensions: 8.8 x 7.2 x 1.3 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #2,813,560 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

25 of 28 people found the following review helpful:

1.0 out of 5 stars Great Title, unfortunately it did not follow through, September 16, 2002

By 

glenn garson (New Orleans, LA United States) - See all my reviews

This review is from: VB.NET & SQL Server 2000: Building an Effective Data Layer (Paperback)

I own about 20 Wrox programming books. This is one of the more disappointing ones in my collection.

I bought the book because I was specifically interested in "Building an Effective Data Layer" with VB.Net, i.e. implementing n-tier applications and specifically the Data Access tier. Unfortunately this important topic rarely came up in the book and when it did it was lost in the details. It does cover the SQLClient, and DataReader, ADO.Net, Data Binding and Stored Procedures. However, other books already do that.

It never specifically covers the "Concept" of tiers, nor the strategy for implementing them (e.g. strategies for passing information between tiers, or using VB.Net's more object oriented features to implement the layers).

The organization and emphasis was weak. The Second Chapter "The SQLClient Namespace" should have been an appendix. The very last chapter is a Case Study which involves a data layer, but the authors fail to explain the strategy and implementation of data tiers using VB .Net.

All-in-all it was very, very disappointing.

6 of 7 people found the following review helpful:

5.0 out of 5 stars Comprehensive guide to building database driven Applications, February 7, 2003

By 

G. Woolf (MA USA) - See all my reviews
(REAL NAME)   

This review is from: VB.NET & SQL Server 2000: Building an Effective Data Layer (Paperback)

Initially the book was a little overwhelming, but as our development team's competence and familiarity with .NET increased, so the later chapters became more valuable. This is especially true of the iBank Case Study, which provides a great "How To..." reference in building a complete enterprise
application using all the elements of .NET based on multiple tiers (Presentation, Business, and Data Layers).

The book's highly professional structure and coding techniques demonstrates the authors' deep knowledge and experience in the SQL/VB.NET domain.

1 of 1 people found the following review helpful:

5.0 out of 5 stars A lost classic, February 15, 2004

By 

DAVID BULOG (Auckland New Zealand) - See all my reviews

This review is from: VB.NET & SQL Server 2000: Building an Effective Data Layer (Paperback)

A lost classic
This is a great book -unfortunatly overlooked.
A great partner to my other fave Wrox title-Proffesional VB Design patterns.

My favorite chapters are Chapter 9 Component Services and Chapter 12 Case Study IBank
You will have to work really hard on the case study 40hrs-80hrs + to get a real gain from this book but unlike some other Wrox books - its not over the top.