asp.net 2 profiles and my database
Hello,
i'm researching building a site in asp.net 2
i will need to handle 2 types of user that can register and loging. reading articles on asp.net 2 it looks like i can use the prifle/membership/role providers to handle a lot of this stuff. for example i can add entries to the web.config to collect extra information about my users (i want to collect phone numbers/address info etc)
my question is, i have designed the rest of my database for the site. but how do i relate a user to other entities in the database?
should i add my tables into the aspnetdb?
or should i have them in a separate db?
for example in my database a user can have 1 or more skills how do i relate the 2? i don't mean in the "the profiles userid pk would be the skill tables fk" way
Re: asp.net 2 profiles and my database
re-reading my post i guess my real question is should i put my tables in the aspnetdb database, or should i have them in a separate database and then have to do cross server joins every time i want to relate a skill to a user (which doens't seems to make sense)