ASP Authentication and with my own database

[jamie_pattison]

I am using ASP .Net forms membership in a site which allows users to log on and allows me to use the methods built in etc. With this in mind i have my own database which collects data from the user. I would like to use the logged on users details but in my own database.

I could retrieve the logged on username and ID then insert it into my database but this would cause repetitive records for the same user and wont be "normalised" data.
If i create another table in my own database to store the users then i may have to first check to see if the current userID exists if not then insert it - personally this feels a little long winded as i have to make a couple of calls to the database just to check if a user exists and then insert.

Any other ways that anyone could advise? Or appropriate ways to have the membership from asp .net and my own database?

Thanks

 

[jmcilhinney]

You can choose any database to install the membership schema, so you just put it in the same database as the rest of your schema. The SQL Server Registration Tool will do the deed and let you select the database.

ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe)