April 10, 2011 at 2:43 pm
Hi.
i have to create database for E-Commerce and Social Networking Website. Both have the common login-registration form.
So my question is:
1. Shall i use default asp.net_membership, asp.net_roles,asp.net_users etc table generated by visual studio .net
or shall i create the table by my self.
2. if i have to create the table(membership, users, roles by my self) so shall i take GUID as primary key for uniqueness or Int
April 11, 2011 at 1:35 pm
If you will change the structure of the tables (e.g. by replacing GUIDs with Int's) you will break Microsoft implementation of Membership, Role providers (stored procedures, permissions model, .NET implementation etc).
I wouldn't recommend this approach if it's not crucial for your scenario, as it will be counterproductive.
You've plenty information on the web on how to create Application Services databases
For .NET 2.0
- ASP.NET SQL Server Registration Tool (Aspnet_regsql.exe) http://msdn.microsoft.com/en-us/library/ms229862%28VS.80%29.aspx
- Creating the Application Services Database for SQL Server http://msdn.microsoft.com/en-us/library/x28wfk74%28VS.80%29.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply