how do I integrate the aspnet_users table that comes with asp.net membership into my existing databa
Posted
by ooo
on Stack Overflow
See other posts from Stack Overflow
or by ooo
Published on 2010-05-22T19:37:50Z
Indexed on
2010/05/22
20:00 UTC
Read the original article
Hit count: 191
sql-server
|asp.net-membership
i have a database that already has a users table
COLUMNS:
userID - int
loginName - string
First - string
Last - string
i just installed the asp.net membership table. Right now all of my tables are joined into my users table foreign keyed into the "userId" field
How do i integrate asp.net_users table into my schema? here are the ideas i thought of:
Add a membership_id field to my users table and on new inserts, include that new field in my users table. This seems like the cleanest way as i dont need to break any existing relationships.
break all existing relationship and move all of the fields in my user table into the asp.net_users table. This seems like a pain but ultimately will lead to the most simple, normalized solution
any thoughts?
© Stack Overflow or respective owner
