asp.net 2 role and membership and other tables
Hello,
i've just started writing an asp.net 2 application that will require users to login
etc etc.
I was going to have a look at using the built sql server role and membership providers. My question is this:
I have other tables that need to be related to users. for example in my app
a "member" may have many projects, so there will need to be a (prefereably ri) relationship between the 2 tables.
But can i/should i put my tables into the same database or do i have to keep them separate? also i presume there is a primary key in the member table?
Re: asp.net 2 role and membership and other tables
I keep them in the same database, there is nothing special about the asp member/role tables as far as SQL server is concerned
Re: asp.net 2 role and membership and other tables
Of course in the same database. You only need to link them using foreign keys.