ASP.NET Custom MemberShip Provider Database

Here i'm explaining how to Create And Use Custom MemberShip Provider Database in ASP.NET 2.0,3.5.4.0. If you want to use Custom or your own DataBase as membership Provider instead of ASPNETDB.MDF database provided by asp.net membership provider class, than follow the steps mentioned in this article.

In this example i m going to describe how to change and use custom Database with Login Control in ASP.NET.

First of all you need to create DataBase schema for membership.
For this create a DataBase in sql server with any name you want.
Now open Visual studio command prompt and type aspnet_regsql , press enter
this will open wizard window to setup database for membership provider

Alternatively you can Go to C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 and run aspnet_regsql.exe from there
Follow the steps according to images

 

 Choose your Database Server and DataBase Name 

Now open web.config file and write below mentioned code 

Add connection string

<connectionStrings>
    <add name="ConnectionString" 
    connectionString="server=AVDHESH\SQLEXPRESS;
    database=CustomMembership;uid=amit;password=password;"/>    
  </connectionStrings>

Now add this code in System.web section of web.config

<roleManager defaultProvider="CustomProvider">
 <providers>
 <add connectionStringName="ConnectionString" 
      name="CustomProvider"
 type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>

<membership defaultProvider="CustomMembershipProvider">
<providers>
<add name="CustomMembershipProvider"
     type="System.Web.Security.SqlMembershipProvider"
     connectionStringName="ConnectionString" />
</providers>
</membership>

After this click on website menu in Visual Studio and select ASP.NET Configuration 
GO to Provider Tab and click on Select a different provider for each feature (advanced) option 

Now create users by going to security tab 
Your custom membership provider with your own custom databse configuration is done 
Build and test the application 

Tweet

If you like this post than join us or share