quote:Originally posted by VerbatimBOT
but here's how it works: when you create a membership user, the aspnet_users table contains 2 rows for each user. One record is related to the record from the aspnet_membership table, and the other one is related to aspnet_usersInRoles.
I hate to spoil the fun, but this is *not* how it works.
When you create a user and add it to a role, you get the following records:
1 record that contains the base user data used by all providers. User ID for example: 27fea12d-a12d-4463-a3f6-d0491aca1316
1 record, with all the Membership data for a user.
User ID is the same as in the _Users table as it is in fact a reference: 27fea12d-a12d-4463-a3f6-d0491aca1316
1 record: a link between a RoleID (for example 43861e10-4666-474d-ab11-700c95e536bf) and the User's ID from the aspnet_Users table (27fea12d-a12d-4463-a3f6-d0491aca1316)
If you're seeing something else, something is seriously wrong.
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results
and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post