Hi

To create DNN user programmatically please use DNN framework 'C#', instead of SQL. If you use core DNN methods, your code can be reused across multiple DNN versions v8+, v9+ etc. Below is a simple code snippet to create DNN user:

public UserInfo DnnUser_Create(string username, PortalSettings portalSettings)
{
//check if user already exists in DNN
DotNetNuke.Entities.Users.UserInfo _userInfo = DotNetNuke.Entities.Users.UserController.GetCachedUser(portalSettings.PortalId, username);

//user not exists in DNN, let's create him
if (_userInfo == null)
{
//create user
_userInfo = new UserInfo();
_userInfo.Username = username;
_userInfo.PortalID = portalSettings.PortalId;
_userInfo.Membership.Approved = true;
_userInfo.Membership.CreatedDate = DateTime.Now;
_userInfo.AffiliateID = DotNetNuke.Common.Utilities.Null.NullInteger;
_userInfo.Membership.Password = "MySecretPassword";

DotNetNuke.Security.Membership.UserCreateStatus userCreateStatus = UserController.CreateUser(ref _userInfo);
if (userCreateStatus != DotNetNuke.Security.Membership.UserCreateStatus.Success)
{
throw new Exception;
}
}

return _userInfo;
}

Thank you very much or your great support.

If I use the mobile app to connect with this, how can I do this? Hope we cannot use the DNN framework for the mobile app.

(Is there a special reason not to recommend SQL user registration? It could be easier since we will use the same database for the web platform and for the mobile platform)