This sample is a demonstration of using LINQ to SQL through a business layer. In
this application all data access occurs through business components which derive
from the wwBusinessObject base class.
This sample consists of 3 projects:
- TimeTrakkerWeb - The Web/UI front end project
- TimeTrakkerBusiness - application specific business objects
- Westwind.BusinessFramework - a simple business object wrapper for LINQ to SQL
Web ConfigurationThe sample is set up to run as a virtual under
http://localhost/TimeTrakkerWeb/
rather than with the local Web server, due to an odd configuration issue that
causes file paths not to be resolved properly by the Visual Studio Web Server. If you have to use Visual Studio Web Server note that styles
and images won't load until you login (top right).
To configure IIS go into the Web Project properties and use the Create Virtual
Directory option assuming you have IIS installed on your machine.
Database Setup
The sample is set up to run against the
TimeTrakker database stored in the App_Data directory. By default the app points
to SQL Express as a file resource. You can change the ConnectionString in
web.config to a full SQL server instance by adjusting the name of one of the
alternate entries.
User Setup and Sample Default Login
The sample uses a user table (Users) in the SQL database to validate users. The
default user info is:
Username:
rstrahl@west-wind.com
Password:
ww
If you want to play around with the sample
data you should log in with this account. To add a new user manually just add a
new record to the Users table in the database - there's currently no UI to do this through code.