how do I integrate the aspnet_users table (asp.net membership) into my existing database

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:10 UTC
Read the original article Hit count: 183

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:

  1. 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.

  2. 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

Related posts about sql-server

Related posts about asp.net-membership