.NET Enterprise Design with Visual Basic .NET and SQL

Jimmy Nilsson is the owner of the Swedish consulting company JNSK AB. He has been working with system development for 13 years (with VB since version 1.0) and, in recent years, he has specialized in component-based development, mostly in the Microsoft environment. He has also been developing and presenting courses in database design, object-oriented design, and so on at a Swedish university for six years. Jimmy is a frequent speaker at Fawcette and Wrox Conferences and has written numerous technical articles. Even so, he considers himself to be mainly a developer.

(NOTE: Each chapter concludes with Whats 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 SHARP. 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. Index.