Murach's VB.NET Database Programming
with ADO.NET (1.x edition)

This chapter presents techniques that can be critical to developing efficient database applications for the web: how to work with connection pooling; how to use ASP.NET's caching feature; and how to maintain the state of each user session for an application.

Chapter 13 Programming techniques for ASP.NET database applications
How to use connection pooling and caching 410
How connection pooling works 410
Connection string settings that affect connection pooling 412
How to use a configuration file to store connection information 414
How to cache data objects 416
A Vendor Display program that uses caching 418
The code for the Vendor Display program 418
How to maintain session state 422
Why session state is difficult to track in web applications 422
How ASP.NET tracks sessions 422
How to use the session state object 424
A Vendor Maintenance program that maintains session state 426
The code for the Vendor Maintenance program 428
The code for the database classes 436
Perspective 442
t


© Copyright 1998-2008 Mike Murach & Associates, Inc.  All rights reserved.

Murach's VB.NET Database Programming with ADO.NET

Learn more about this book

Add this book to your cart