I never thought that transferring the built-in ASP.NET Membership tables to my own database is as easy as changing the default connection string. Here are the steps:
1. Add a LINQ To SQL Class to your MVC Project. Point your new class to your database by adding a table to the dbml file. This will add a new connection string in your Web.config.
2. Open the Web.config file and comment out the DefaultConnection item in the <connectionStrings> tag. Cut and paste the newly created connection string and rename it as DefaultConnection. Compile and run your project and register a sample user.
Thats it! Try opening your database using your the management tool and look for the newly created tables.
If you find this blog helpful, you can make the donation by clicking the Paypal button below.