Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 14th, 2006, 04:49 AM
Registered User
 
Join Date: Sep 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Roles and membership asp.net 2

hi

i have my whole database and also have tables for user login etc. Now i want to use my tables not the tables generated by aspnet_regsql for roles and membership. its client requirement that i must use tables he has provided me. he has two different tables, one for end users and one for admins. and he dont want it to be changed. Is there any way i can use these tables and implement .net 2 feature of memberships and roles.

please help.

thanks in advance
  #2 (permalink)  
Old September 22nd, 2006, 03:34 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

zeeshannasir: It is not clear as to what level the two tables will be applied, however I am responding from the Point Of View (POV) of the application level. In your database, create a RoleTbl, defines all the possible Roles:
RoleTbl
RoleID RoleDescription
1 Role A
2 Role B
3 Role C
Another helpful table, if it does not exist already is an Application Table:
AppID ApplicationDesc
1 App 1
2 App 2
Now you can create the relationships, 1) Identify the Admin in each Application:
AdminAppTbl
AdminAppID AdminID AppID
1 1 1
2 1 2
3 2 3
Next you would create a EndUserRoleTable By Application. This will be one of your largest table because it allows for your end users to have access to different and multiple applications and roles maybe.
EndUserRoleTbl
EURID EndUserID RoleID AppID
1 EU1 1 1
2 EU1 1 2
3 EU2 2 1
One constraint that should be considered here is if the Admin is also an End User. I would think that "Admin" is a type of Role. Just a thought.

Hope this helps.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Membership and Roles doesnt work Baby_programmer ASP.NET 2.0 Professional 2 July 29th, 2008 09:41 AM
ASP.NET Membership and ActiveDirectory Quick209 ASP.NET 2.0 Professional 0 June 13th, 2007 12:41 PM
Help with ASP.NET Membership VerbatimBOT SQL Server 2000 6 May 2nd, 2007 01:58 PM
Roles and membership asp.net 2 zeeshannasir ASP.NET 2.0 Basics 2 September 15th, 2006 07:24 AM
Retrieving Roles using C# / ADSI in ASP.Net app Prashant.k.m ASP.NET 1.0 and 1.1 Professional 0 October 4th, 2005 04:28 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.