Membership - CreateUserWizard

[wallm]

I'm using the CreateUserWizard and the ASPNETDB.mdf database.
If I create a new database table I would like to create a relationship between the aspnet_Membership table and my new Orders table.
I'm not sure how to do this. Would I need to get the UserID for the newly created member and place that in the new table?

thanks.

 

[BoulderBum]

The user ID is the primary key for the aspnet_Users table so you'd want to create a foreign key constraint from your Orders table to the aspnet_Users table.

From there, whenever a user places an order, you should be able to retrieve the key (which is a uniqueidentifier/GUID) thusly:

Guid userKey = (Guid)Membership.GetUser(User.Identity.Name).ProviderUserKey;

'Now insert a record in the Orders table using the key.

 

[wallm]

thanks for your help.
I've just been advised that membername is also unique.

 

[BoulderBum]

Actually, UserId is the only value associated with a user that's guaranteed to be unique by database constraints. Concevably you can have multiple applications using the same membership database where the UserName field will be identical.

Additionally, there's no index associated with aspnet_Users.UserName so you may run into performance pitfalls with joins to that field unless you do a little manual index tuning.

There is, however, a clustered index on ApplicationId/LoweredUserName so you may want to look into that if you want to use LoweredUserName.