{"id":128600,"date":"2023-05-08T12:06:19","date_gmt":"2023-05-08T06:36:19","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128600"},"modified":"2024-04-12T14:15:28","modified_gmt":"2024-04-12T08:45:28","slug":"creating-the-membership-database","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-membership-database\/","title":{"rendered":"Creating the Membership Database"},"content":{"rendered":"\n

Creating the Membership Database<\/strong><\/h4>\n\n\n\n

To create a membership database for an ASP.NET application, you can use the ASP.NET Web Site Administration Tool or run SQL scripts that create the necessary database schema.<\/p>\n\n\n\n

Here are the steps to create the membership database using the Web Site Administration Tool:<\/p>\n\n\n\n

Open Visual Studio and create a new ASP.NET Web application.<\/p>\n\n\n\n

In Solution Explorer, right-click the project and select “Add ASP.NET Folder” -> “App_Data”.<\/p>\n\n\n\n

In the App_Data folder, right-click and select “Add New Item”.<\/p>\n\n\n\n

Select “SQL Server Database” and enter a name for the database (e.g., “MembershipDB.mdf”). Click “Add”.<\/p>\n\n\n\n

In Server Explorer, select the new database and choose “New Query”.<\/p>\n\n\n\n

Execute the following SQL script to create the necessary schema:<\/p>\n\n\n\n

css<\/p>\n\n\n\n

Copy code<\/p>\n\n\n\n

aspnet_regsql.exe -E -S localhost\\SQLEXPRESS -d MembershipDB -A all<\/p>\n\n\n\n

This will create the necessary tables and stored procedures for the membership system in the MembershipDB database.<\/p>\n\n\n\n

Alternatively, you can manually create the schema by executing the appropriate SQL scripts. The scripts are typically located in the “C:\\Windows\\Microsoft.NET\\Framework\\v4.0.30319” folder. The scripts are named “InstallCommon.sql”, “InstallMembership.sql”, “InstallProfile.sql”, and “InstallRoles.sql”.<\/p>\n\n\n\n

Once the membership database has been created, you need to configure the ASP.NET application to use it. This involves updating the web.config file with the connection string to the database and setting the appropriate membership provider settings.<\/p>\n\n\n\n

This Web application uses a SQL Server Express database to store user information. The Fabrikam site recognizes three categories of users:<\/p>\n\n\n\n