Home > Store

.NET Enterprise Design with Visual Basic .NET and SQL Server 2000

Register your product to gain access to bonus material or receive a coupon.

.NET Enterprise Design with Visual Basic .NET and SQL Server 2000


  • Your Price: $43.99
  • List Price: $54.99
  • We're temporarily out of stock, but order now and we'll send it to you later.


  • Copyright 2002
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 384
  • Edition: 1st
  • Book
  • ISBN-10: 0-672-32233-1
  • ISBN-13: 978-0-672-32233-4

This book discusses factors and opinions developers should consider in order to create higher quality designs and applications. The author uses one large-scale business application throughout the book as the basis for all examples to clearly illustrate concepts being discussed.

Coverage also includes:

  • a variety of aspects about design in the world of .NET;
  • explanations of the business and data access layers of application design;
  • solutions for problems such as code structure, solid error trapping, and how to build in debugging support;
  • discussion of how to design larger projects with more robust systems and reusable components;
  • comparison of component solutions to stored procedure solutions.



The source code for the examples developed in the book, additional resources, and errata can be found on the author's companion website at http://www.jnsk.se/book/.

Sample Content

Online Sample Chapters

Configuration Data

Have Only One Controlling Part of a Transaction

Introduction to COM and .NET

Reasons for Using Both RETURN() and RAISERROR()

VB.NET and SQL Server 2000: One Controlling Part of a Transaction

Table of Contents

(NOTE: Each chapter concludes with What's Next and a Reference Section.)

1. Introduction.

The History of COM, MTS/COM+, VB, and SQL Server. The New World of .NET. COM+ 1.5 Component Services. Visual Basic .NET. C#. SQL Server 2000.

2. Factors to Consider in Choosing a Solution to a Problem.

Type of Consumer. Physical Restrictions and Possibilities. Performance. Scalability. Other “-abilities” (Such as Maintainability, Reliability, Reusability, Testability, Debuggability, and Interoperability). Security. Farm- and Cluster-Enabling.

3. Testing.

A Short Introduction to Testing. Support for Automatic Testing with a Standardized Test Bed. Assertions. The Diagnose/Monitor Tool. Miscellaneous Tips. Evaluation of Proposals.

4. Adding Debugging Support.

Tracing. Error Logging. Reflection, Interception, and Attributes to Your Service. Configuration Data. Evaluation of Proposals.

5. Architecture.

Three Examples of Architectures. Sample Application: Acme HelpDesk. My Architecture Proposal: A .NET-Adjusted Version of DNA. New Concepts to Consider When Creating a New Architecture Today. Physical Partitioning. Proposals for Standardized Code Structures. Evaluation of Proposals.

6. Transactions.

Choosing a Transaction Technique. Transactions in the Proposed Architecture. A Flexible Transaction Design. New Possibilities to Consider with .NET. Tips on Making Transactions as Short as Possible. Tips on Decreasing the Risk of Deadlocks. Obscure Declarative Transaction Design Traps. Evaluation of Proposals.

7. Business Rules.

A Short Introduction to Business Rules. Location and Solutions of Business Rules. Proposal for Where to Locate Different Business Rules. Business Rule Tips. Evaluation of Proposal.

8. Data Access.

My Proposal for a Data Access Pattern. The Data Access Proposal in the Architecture. Saying More in Fewer Words When Calling Stored Procedures. Server-Side Caching. Dealing with Schema Changes. Evaluation of My Proposal.

9. Error Handling and Concurrency Control.

My Proposal for How to Handle Errors. Exceptions to Be Prepared For. Approaches to Concurrency Control for Disconnected Scenarios. Evaluation of Proposals.

Appendix A. Suggestions for Further Reading.



Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership