Good afternoon ASP programmers,
In my application Members are created in a process, by the club administrator. If a member wants access to the secure areas of the website he must use the page that contains the CreateUserWizard to create his login account. The membership data is contained in the Members table and has IDMember as the PK. I have added IDMember to the aspnet_Users table as a FK. When I create a new user with the CreateUserWizard, I also need to Insert the IDMember of the new user into the aspnet_Users table along with all the other data from the CreateUserWizard.
In the CreateUserWizard's CreatingUser event handler I used LINQ to SQL to query the Members table to insure that the user is a valid member and to extract his IDMember. I also query the aspnet_Users table to insure that the user had not previously created a login account. If these two test are not passed I set e.c ...
Go to the complete details ...