Microsoft® Visual Studio® 2010 Unleashed

Create the Database and Data Access Library

For this solution, you need to store the request details somewhere. You could implement an email based system that send details in emails and allowed someone to approve through their email client. In this case, however, you will create a simple table to store the travel request in a queue for approval and tracking (different from the workflow tracking service).

Creating the Database

To create the database we recommend you simply copy the TravelRequest.mdf file to your machine from the downloadable content for the book. However, if you want to create it from scratch you should follow the outline shown in Figure 23.26.

Figure 23.26 The TravelRequest.mdf acts as the queue of requests waiting approval ...