There is much more involved in adding a user than simply adding an entry to the DNN Users table via the AddUser sproc. Many tables such as aspnet_Membership, aspnet_Users, UserPortals, UserProfile, and UserRoles are also affected. Other side effects such as the sending of new user emails, password encryption, etc. are handled in application code not SQL manipulation.

Have you considered calling the appropriate API methods in the UserController and other related class instead of a SQL approach or taken a look at the DNN framework source code? The DotNetNuke.Entities.Users.UserController.CreateUser method is a good place to start. In addition to not being sufficient in this case, executing core SQL sprocs such as AddUser or any manipulation of the data in core DNN tables is asking for trouble when it comes time to upgrade your DNN installation. Although there is some possibility that core framework methods might change as part of an upgrade, the core team makes every effort not to introduce breaking changes. There is no such guarantee when it comes to core tables or sprocs - those have and will continue to undergo many changes with each version upgrade.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner