This is a starter kit, which includes very simple user requirements, where we can create, read, update and delete (CRUD) the employee info of a company.
The primary purpose of this starter kit is, to provide a solid guideline with respect to building enterprise level projects, by utilizing asp.net 2.0 and Sql server 2005 features, as well as latest best coding practices.

The starter kit includes several cases where we can perform multi-table joining and/or write operations. Combining high performance and security features this starter kit shows how we can solve in real world problems and challenges, from a wide range of view point.

Minimum System Requirements

• Visual Studio 2005 (or higher)
• Sql Server 2005 or higher

User End Functional Specification

The user end functionalities of this starter kit are pretty simple and straight forward that are focused in to perform CRUD operation on employee records as described below.

Creating a new employee record
The users should be able to create new employee record, one at a single time.
Read existing employee record
The users should be able to view the employee records in list style, where maximum 10 records can be visible per page and the list can be filtered out based on their supervisors. The user should also be able to view employee records with details, once at a single time and can print it in a printable format.
Update an existing employee record
The users should be able to update an existing employee record, one at a single time.
Delete existing employee records
The users should be able to delete single or multiple employees at a time while viewing employee records in list style.

Architectural Overview

• Simple 2 layer architecture (user interface and data access layer) with 1 optional cache layer
• ASP.NET Web Form Based User Interface
• Custom Entity Data Container implemented (with primitive C# types for data fields)
• Static type CRUD methods embedded with Data container, implemented in C#
• Sql Server Stored Procedure to perform actual CRUD operation
• Automated testing infrastructure to ensure quality

Technology Utilized

Programming Languages/Scripts

• Browser side: JavaScript
• Web server side: C# 2.0
• Database server side: T-SQL

.NET Framework Components

• .net 2.0 generic type
• .net 2.0 nullable type
• asp.net 2.0 object data source
• asp.net 2.0 grid view
• asp.net 2.0 form view
• asp.net 2.0 skin
• asp.net 2.0 theme
• asp.net 2.0 master

Visual Studio Features

• Visual Studio Unit Test
• Visual Studio Database Unit Test
• Visual Studio Web Test
• Visual Studio Load Test
• Visual Studio Ordered Test

Sql Server Features

• Sql server 2005 Stored Procedure
• Sql server 2005 Xml type
• Sql server 2005 Paging support