Hello all,
I want to setup a db which is expected to grow in tables.
Now I have few points where I am confused about how to manage things.
1. Is it necessary to keep foreign keys in DB?
2. I prefer using ASPNET default db for any membership related works, but in this application there will be a super admin, then he will be creating different users and assign them role admins. Now these admins can log into system and have their own roles for their work setup. Some of them may contain same role name but should be identified by person who created them. It means how do I manage roles which will not affect roles of another admin in the default ASPNET db, roles may contain same name but identified by their admins.
3. Now admins can create their own users who will work under his work setup, logicaly / idealy there may be users with same name in different admins' work setup but if we talk about aspnet db then it does not allow to create users with same name, so please tell me how I can create users which may contain same username under different admins and it does not break db.
Please tell me how this can be handled within ASPNET DB., will I need to create my own DB structure for user related informations.
Expecting more reliable and concrete solution from asp.net gurus.
Thanks