Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how create a sql membership tables in my custom database in visual studio 2012

I used to create website projects in vs2010 and create a simple SQL MEMBERSHIP SCHEMA into another database hosting server, like GoDaddy. My database schema tables looks like this.

aspnet_Applications
aspnet_Membership
aspnet_Paths
aspnet_PersonalizationAl lUsers
aspnet_PersonalizationPeruser
aspnet_Profile
aspnet_Roles
aspnet_SchemaVersions
aspnet_Users
aspnet_Usersl nRoles
aspnet_Web Event_Events

But now Im Trying the new VS2012. The default Project creates a local database with the fallowings tables:

Applications
Memberships
Profiles
Roles
Users
UserslnRoles

, this is totally diferent from the schema that i used to see. there is no aspnet_ prefix and the tables are diferent... i cannot just rename the tables.

The aspnet_regsql tool creates the old version. with the aspnet_ prefix..

How can I create this new schema in Visual studio 2012??

like image 856
Daniel Santos Avatar asked Jan 27 '26 04:01

Daniel Santos


1 Answers

Ok after somre researsh this is a solution..

in vs2012, when using asp.net framework 4.5, there i no need to create this tables. You just put the correct connectrions string on web.config file and name it as "DefaultConnection".

When your register form tries to create a new user account, it verifies if the tables exists and create all the tables by it self.

That is it , simple as it goes.

like image 193
Daniel Santos Avatar answered Jan 29 '26 20:01

Daniel Santos



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!