Programming Microsoft® ADO.NET 2.0 Applications: Advanced Topics

Chapter 11. Retrieving Metadata

Imagine that you’ve written an order entry application that is highly dependent on a backend database server. All of your code gains access to the data through stored procedures that you have written. The application is deployed, and a couple hundred users enter customer and order information all day long.

Now imagine that you need to add a new field that contains the customer’s credit limit. You must add this field to the customer screen in the application and add business logic to ensure that new orders cannot be entered if the customer’s credit limit has been exceeded. Of course, you must add this field to the customer table in the database and modify the stored procedures for retrieving and modifying the customer ...