Solved

ASP.NET Membership Provider -

Posted on 2007-03-20
8
419 Views
Last Modified: 2011-04-14
Hi experts,
   I want to set up a Membership provider for an asp.net 2.0 application. The provider will use a sql server 2005 database. The user table contains email addess and user name and password and security question and security answer but also various other fields for address and postcode and job title and various telephone numbers etc. I also want to hold adresses in a separte table linked by a foreign key and also security questiion details, user types and user status details in separate tables and have access to the data managed through the membership provider. What I'm confused about is whether I can include these extra fields in the user table and use the built in membership provider or whether I need to extend the built in membership provider or whether I need to produce a custom membership provider.
0
Comment
Question by:JamesJMcDonnell
  • 5
  • 2
8 Comments
 
LVL 19

Expert Comment

by:DreamMaster
ID: 18755741
You could try profiles:

http://msdn2.microsoft.com/en-us/library/taab950e(vs.80).aspx
http://weblogs.asp.net/scottgu/archive/2005/10/18/427754.aspx

Especially Scott Gu's entry on this is very easily understandable and very clear.

Regards,
Max.
0
 

Author Comment

by:JamesJMcDonnell
ID: 18756210
Thanks Max,
   However, I want to avoid using the profile store. I want to use one SQL Server table, tblUser, to store the main user information. User records are being created in the application through registration but are also being imported into the application from another application.

Regards
James
0
 
LVL 19

Accepted Solution

by:
DreamMaster earned 500 total points
ID: 18759647
In that case you will HAVE to extend the membership provider to add the extra fields.

Regards,
Max.
0
 
LVL 3

Expert Comment

by:Kate12
ID: 18762609
I agree with Sage. I have done this in the past and you'll have to extend your membership provider.
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 19

Expert Comment

by:DreamMaster
ID: 18762898
LOL, Sage is my rank, not my name Kate12 ;)

Regards,
Max.
0
 
LVL 3

Expert Comment

by:Kate12
ID: 18762912
Yo!  But "DreamMaster" was too much for my self-ego to speak out you true name.... :-p
0
 
LVL 19

Expert Comment

by:DreamMaster
ID: 18764316
Max would have been fine as well ;) Sorry JamesJMCdonnell for making a mess of your question.

Regards,
Max.
0
 
LVL 19

Expert Comment

by:DreamMaster
ID: 18781640
Glad to have been helpful :)

Regards,
Max.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Mutually exclusive checkbox in a gridview 18 41
Problem to picture file 3 40
c# code 19 58
Image(7) 1 33
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now