ASP .Net membership and membership class

Question

Couple of questions:

I have a database i created under the app_data folder. Is there anyway to associate this database with an EXISTING aspnetdb which is also under the same folder? If so could anyone guide me?

If not then what would be the best way to create my own database under the APP_CODE folder which would also utilise asp .net membership? By that i mean i could check for username and roles theyre in, in code (If User.IsinRole("........") etc and use the icon inside the project to open the membership page and add/modify/delete users too?

Thanks

Answer 1

All you need to do is change the connection string to point to the same database for both. Of course, you will have to copy the schema from one to the other, and any data you need.

Answer 2

You can create a MembershipProvider. An example is available at code project, Custom Membership Providers

Answer 3

You can create your custom Membership Provider because you have custom dataBase, not the generated dataBase with aspnet_regsql.

public class CustomMembershipProvider : MembershipProvider
{   
    public override MembershipUser CreateUser(string username, 
       string password, string email, string passwordQuestion, 
       string passwordAnswer, bool isApproved, 
       object providerUserKey, out MembershipCreateStatus status)
    {
        throw new NotImplementedException();
    }

    public override MembershipUser GetUser(string username, bool userIsOnline)
    {
        throw new NotImplementedException();
    }

    public override bool ValidateUser(string username, string password)
    {
        throw new NotImplementedException();
    }

    public override int MinRequiredPasswordLength
    {
        get { throw new NotImplementedException(); }
    }

    public override bool RequiresUniqueEmail
    {
        get { throw new NotImplementedException(); }
    }
}

You register your memberShip provider

<connectionStrings>
    <add name="ApplicationServices" 
      connectionString="Server=your_server;Database=your_db;
                         Uid=your_user_name;Pwd=your_password;"
      providerName="System.Data.SqlClient" />
</connectionStrings>

<authentication mode="Forms">
  <forms loginUrl="~/Account/LogOn" timeout="2880" />
</authentication>

<membership defaultProvider="CustomMembershipProvider">
  <providers>
    <clear/>
    <add name="CustomMembershipProvider" 
        type="CustomMembership.Models.CustomMembershipProvider"
        connectionStringName="AppDb"
        enablePasswordRetrieval="false"
        enablePasswordReset="true"
        requiresQuestionAndAnswer="false"
        requiresUniqueEmail="false"
        maxInvalidPasswordAttempts="5"
        minRequiredPasswordLength="6"
        minRequiredNonalphanumericCharacters="0"
        passwordAttemptWindow="10"
        applicationName="/" />
  </providers>