The projects in this document let you apply the programming skills you learn in Murach’s ASP.NET 4.5 Web Programming with C# 2012 by developing an application called SportsPro. This application is designed for the technical support department of a hypothetical software company that develops software for sports leagues. The purpose ofthe application is to track technical support service calls (referred to as incidents) in a database that also stores information about the company’s customers, software products, and technicians. The application uses a database called TechSupport. Before you do any of the projects, you should read the introductory information that follows.
How to prepare for using the TechSupport
All of the projects for this book use a SQL Server version of the TechSupport database. To get the files you need for working with this database, you can copy the executable Zip file that your instructor gives you, TechSupport.exe, to your C drive. Then, you can double-click on this file in Windows Explorer to extract the files it contains to the C:Murachaspnet45_vbproject_database directory. If you’re using SQL Server Express LocalDB, you can use the TechSupport.mdf and
TechSupport_log.ldf database files in this directory. To do that, just copy these files into
the App_Data folder of the application.
If you’re using SQL Server Express instead of LocalDB, you’ll need to create the TechSupport database. To do that, you can navigate to the project_database directory and double-click on the create_TechSupport.bat file to execute it. This batch file runs a SQL Server script named create_TechSupport.sql that creates the database in the copy of SQL Server running on your computer. Note that if the database server on your system has a name other than the computer
name appended with SQLEXPRESS, the batch file we provide won’t work. But you can
easily change it so it will work. To do that, just open the file in a text editor such as NotePad. When you do, you’ll see a single command with this server specification:
sqlcmd -S localhostSQLExpress -E /i create_TechSupport.sql
Then, you can just change this specification to the name of your server.