The Chapter 6 download has a few issues that can be easily handled.

First, the Chapter6RoleBasedSecurity SQL Script is missing four Stored Procedures,
ENTRoleCapabilitySelectAll, ENTRoleUserAccountSelectAll, ENTRoleUserAccountSelectById, and ENTRoleCapabilitySelectById.

These Stored Procedures can be copied from FinalDBWithData download.

Second, ENTUserAccountData.cs, in the Chapter 6 DAL Framework, has a method
SelectByWFOwnerGroupId which accesses ENTUserAccountSelectByENTWFOwnerGroupId. The bottom of page 168 says that ENTUserAccountData is unchanged.

Copying ENTUserAccountData from Chapter 4 download works.

Third, ENTUserAccountEO Class has a method LoadByWFOwnerGroupId which accesses SelectByWFOwnerGroupId which was in the ENTUserAccountDATA module.

Commenting out the routine works.

Thanks, I was looking for those stored procs and thought I had missed something. Took about 45 minutes for me to review my stuff and look back through the scripts before I decided to look on the forum.

Thanks again,
-realkewl