Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Create User Programmatically in 4.7
Previous Previous
 
Next Next
New Post 6/19/2008 11:03 AM
User is offline chris suttman
22 posts
10th Ranked


Re: Create User Programmatically in 4.7 

Never mind.

I used the SQL from an earlier post and it worked like a charm. I can use it from anywhere as long as I use the right connection string.

 
New Post 6/19/2008 11:11 AM
User is offline chris suttman
22 posts
10th Ranked


Re: Create User Programmatically in 4.7 

Oops. The script wasn't in this forum... it was in a blog elsewhere...

http://www.mitchelsellers.com/Blogs/tabid/54/articleType/ArticleView/articleId/84/Creating-a-Standard-DotNetNuke-User-Via-SQL.aspx

 

 

 
New Post 7/26/2008 8:05 AM
User is offline Michael Washington
2641 posts
ADefWebserver.com
5th Ranked










Re: Create User Programmatically in 4.7 

 chris suttman wrote

I used the SQL from an earlier post and it worked like a charm. I can use it from anywhere as long as I use the right connection string.

The problem with using a sql script is that when you upgrade DotNetNuke it can break your code. The worst part about this is that you will not receive any notice of a "breaking change" because the database objects are not considered part of the DNN API because DNN can run on other database platforms such as Oracle.

The database objects in DNN do change frequently mostly due to optimizations.

If the DNN API does have a change it will be announced as a "breaking change". There have been no breaking changes to the user creation classes in years.



Michael Washington
* ADefWebserver.com
* DNN Module Developer's Guide
* IWEB - DNN Web Services
* Silverlight and DotNetNuke
 
New Post 7/26/2008 10:29 AM
User is offline Matt Christenson
138 posts
www.RealSkydiving.com
9th Ranked


Re: Create User Programmatically in 4.7 

Touching the core tables will change your upgrades and testing from a 1-4 hours project to a 8+ hour project.  You should not touch the CORE code or SQL Tables.  You can instead create a new table with a one-to-one relationship with the core users table that extends it with the feild that you need.

When searching for a solution to your problem of creating accounts on another DNN installation, you should consider another option that you have is moving the storage of the user data to another location (such as the same Database as your original DNN installation) through the use of custom membership providers.  You may even find a 3rd party Single Sign On solution that has done most of this work for you.

I have done this in the past, I had 4 DNN installations sharing a single DNN installation's users, but those users were assigned to very different roles from one site to another.  (The different sites were actually 3 competing companies in the same industry, using a common organization as a single sign on provider.)  The solution is no longer in use because of political and business reasons - but from a technical standpoint it worked perfectly.

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Create User Programmatically in 4.7
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


DNN Photo Gallery
Complete Photo Gallery Management!
www.dnnPhotoGallery.com
R2i - Delivering Serious DNN Services & Solutions
Award Winning Design, Skin construction, Custom Modules and Consulting Services for the Enterprise organization. R2i is the DNN:Map module Project Lead and one of the largest DNN service providers with offices in New York City, Virginia and Baltimore.
www.bi4ce.com
"SalarO" Skinning Graphic Design Branding Services
SalarO develops packaged & custom skins for your DNN at prices you can afford. SalarO is also developing Module development, Hosting, Branding/Logo design as well as Content Transfer Services to complement the core skinning solutions.
www.salaro.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP