The membership provider implementation in BugNET is not implemented in the correct manner or best practice. The whole idea behind the membership, role and profile concept is transparency and to be able to store your users and roles in whatever kind of data source and rely on the username to be unique.
BugNET have hard coded relations to the userid in aspnet_membership table and I cannot change my membership provider, when I edit the store procedure BugNet_Role_GetRolesByUser I see some very strange SQL code where there is a join between BygNET table and aspnet_membership table.
A better way is to replace the guid column with userid to a string column where you save the username instead, as I said, the username is unique.
We have a bunch of application all using the membership- and role provider concept and a user is created one in a shared database and can login with the same username/password in all applications as long as the roles allows him.
I love the functionality in BugNET and are in the startup to implement the system as our front desk, but I need to rewrite the username handling.
/Kalle