C# and the .NET Framework: The C++ Perspective

Employee and Department Class

With the basic database framework in place, the next step is to create the Employee and Department classes and their respective stored procedures. To keep focused, the stored procedures will not implement any type of error checking or result codes. Instead, SQLServer® constraints will be used to ensure that there are no primary or foreign key conflicts.

Stored Procedures

The Employee Browser will make use of only four simple stored procedures. SQL Server® Enterprise Manager allows for viewing and creating user stored procedures from the management console. Figure 4.2.2 shows the stored procedure editor contained within SQL Server.

Figure 4.2.2. SQL Server stored procedure editor.

Using the editor, the following stored ...