The ProjectPal Database

Let’s get our hands a little dirtier by looking at the data, code, and techniques used to create the ProjectPal system.

Not all the code in the ProjectPal system is here because of space constraints and the fact that some of the code is quite repetitive. However, you can download the full source code, as mentioned at the beginning of this chapter, or play with it online at

The ProjectPal system uses SQL Server 2000 as its main datasource. The system is made up of various tables, views, and stored procedures. Throughout this section, I assume you have knowledge of SQL Server, SQL Queries, and basic Transact SQL.

Database Schema

The Database schema used by the ProjectPal system is ...

Get Inside ASP.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.