Dynamic Membership Provider

[ryan.mclean]

Hello everyone,

I am wondering, can the membership provider be changed at runtime?
Perhaps the connectionStrin gName?

I would like to use a different database based on the server the site
is on.

I suppose that a custom provider could be used to accomplish this, is
there another way?

It would be great to do the following:
Select Case strEnvironment
Case "PRD"

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for production"
Case Else

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for development"
End Select

Thanks for your input,
Ryan

[Ken Cox [Microsoft MVP]]

Hi Ryan,

Put your default and alternate membership providers (and their connection
strings) in the web.config file, like this:

<membership defaultProvider ="Mydefaultprov ider">
<providers >
<clear/>
<add connectionStrin gName="ASPNETDB ConnectionStrin g1"
name="MyAlterna teprovider"
type="System.We b.Security.SqlM embershipProvid er"/>

<add connectionStrin gName="ASPNETDB ConnectionStrin g2"
name="Mydefault provider" type="System.We b.Security.SqlM embershipProvid er"/>

</providers>
</membership>

Then in your code, reference the one you want to use:

Dim mbr As MembershipProvi der
mbr = Membership.Prov iders.Item("MyA lternateprovide r")
' mbr.CreateUser( ....
Response.Write( mbr.GetType)

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]

<ry*********@gm ail.comwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...

Hello everyone,

I am wondering, can the membership provider be changed at runtime?
Perhaps the connectionStrin gName?

I would like to use a different database based on the server the site
is on.

I suppose that a custom provider could be used to accomplish this, is
there another way?

It would be great to do the following:
Select Case strEnvironment
Case "PRD"

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for production"
Case Else

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for development"
End Select

Thanks for your input,
Ryan

[ryan.mclean]

Thanks for responding so quickly Ken. That did help greatly.

Have a great day,
Ryan
Ken Cox [Microsoft MVP] wrote:

Hi Ryan,

Put your default and alternate membership providers (and their connection
strings) in the web.config file, like this:

<membership defaultProvider ="Mydefaultprov ider">
<providers >
<clear/>
<add connectionStrin gName="ASPNETDB ConnectionStrin g1"
name="MyAlterna teprovider"
type="System.We b.Security.SqlM embershipProvid er"/>

<add connectionStrin gName="ASPNETDB ConnectionStrin g2"
name="Mydefault provider" type="System.We b.Security.SqlM embershipProvid er"/>

</providers>
</membership>

Then in your code, reference the one you want to use:

Dim mbr As MembershipProvi der
mbr = Membership.Prov iders.Item("MyA lternateprovide r")
' mbr.CreateUser( ....
Response.Write( mbr.GetType)

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]

<ry*********@gm ail.comwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...

Hello everyone,

I am wondering, can the membership provider be changed at runtime?
Perhaps the connectionStrin gName?

I would like to use a different database based on the server the site
is on.

I suppose that a custom provider could be used to accomplish this, is
there another way?

It would be great to do the following:
Select Case strEnvironment
Case "PRD"

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for production"
Case Else

ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for development"
End Select

Thanks for your input,
Ryan

[Michael]

Hello,

this is a great solution. I was looking around quite a while for something
like this.
But I have one big problem:

All the membership methods now need all parameters :-(
The Default Membership-Provider accepts a variety of overloaded methods.

example:

' this is the normal way with the defaultprovider - and it works fine:
newUser = Membership.Crea teUser(UserName , Password)

Now with a dynamic provider,you must provide all Parameters:

Dim mbr As MembershipProvi der = Membership.Prov iders.Item("Tes tProvider")

mbr.CreateUser( UserName, Password, "","","",Tr ue, ProviderUserKey , Status)

Is there any solution for this Problem ?

Thanks in advance !

Kind Regards,
Michael

"ry*********@gm ail.com" wrote:

Thanks for responding so quickly Ken. That did help greatly.

Have a great day,
Ryan
Ken Cox [Microsoft MVP] wrote:

Hi Ryan,

Put your default and alternate membership providers (and their connection
strings) in the web.config file, like this:

<membership defaultProvider ="Mydefaultprov ider">
<providers >
<clear/>
<add connectionStrin gName="ASPNETDB ConnectionStrin g1"
name="MyAlterna teprovider"
type="System.We b.Security.SqlM embershipProvid er"/>

<add connectionStrin gName="ASPNETDB ConnectionStrin g2"
name="Mydefault provider" type="System.We b.Security.SqlM embershipProvid er"/>

</providers>
</membership>

Then in your code, reference the one you want to use:

Dim mbr As MembershipProvi der
mbr = Membership.Prov iders.Item("MyA lternateprovide r")
' mbr.CreateUser( ....
Response.Write( mbr.GetType)

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]

<ry*********@gm ail.comwrote in message
news:11******** **************@ i3g2000cwc.goog legroups.com...

Hello everyone,
>
I am wondering, can the membership provider be changed at runtime?
Perhaps the connectionStrin gName?
>
I would like to use a different database based on the server the site
is on.
>
I suppose that a custom provider could be used to accomplish this, is
there another way?
>
It would be great to do the following:
Select Case strEnvironment
Case "PRD"
>
ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for production"
Case Else
>
ConfigurationMa nager.Connectio nStrings("SQLCo nnectionString" ).ConnectionStr ing
= "super-secret connection string for development"
End Select
>
Thanks for your input,
Ryan
>