Re: How to Change Membership provider during runtime

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That helps, Thanks a lot.

"Ken Cox [Microsoft MVP]" wrote:

Hi Balaji,

You need to make sure all the membership providers are listed in the
web.config file, like this:

<membership defaultProvider="Mydefaultprovider">
<providers >
<clear/>
<add connectionStringName="ASPNETDBConnectionString1"
name="MyOracleprovider"
type="System.Web.Security.OracleMembershipProvider"/>
<add connectionStringName="ASPNETDBConnectionString2"
name="Mydefaultprovider" type="System.Web.Security.SqlMembershipProvider"/>
</providers>
</membership>

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

Dim mbr As MembershipProvider
mbr = Membership.Providers.Item("MyOracleprovider")
' mbr.CreateUser(....
Response.Write(mbr.GetType)

Let us know if this helps?

Ken
Microsoft MVP [ASP.NET]


"Balaji" <Balaji@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:92B252CF-E761-468A-8E76-62907EE6FD81@xxxxxxxxxxxxxxxx
Hi All,

Can I use more than one membership provider for a given website? I
understand only one of them could be default one. If yes, then how to
programmatically access the other membership provider? For e.g. lets say I
have a SQLMembership provider and OracleMembership provider. SQL would be
my
default provider. During authentication, based on the value of an
additional
parameter in the login screen, I need to validate against SQL or Oracle
db.
Is this feasible?

I found this on MSDN

"You can also configure multiple membership providers, which allows you to
select a membership provider at run time based on application
requirements.
For example, for business reasons your membership information might be in
separate regional databases. By configuring multiple membership providers
that each interact with a different regional database, you can direct
membership calls to the appropriate provider for different users."

http://msdn2.microsoft.com/en-us/library/sx3h274z.aspx


Any idea on how to switch Membership provider during runtime?

Thanks for tip,
-Balaji NJL





.

Relevant Pages

  • Re: GenericPrincipal
    ... I think if you want to use your existing user database, ... The default one doesn't necessarily require SQL express, ... SQL membership provider is freely available for you to look at and modify. ... Co-author of "The .NET Developer's Guide to Directory Services Programming" ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to Log Out
    ... Dominick Baier - DevelopMentor ... SQL 2005 Membership provider. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to Change Membership provider during runtime
    ... Can I use more than one membership provider for a given website? ... I need to validate against SQL or Oracle ... "You can also configure multiple membership providers, ... separate regional databases. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Login control - remember me
    ... I'm simply comparing the username and password values with those stored ... in my sql db. ... Is it necessary to use a membership provider for the cookie to be ...
    (microsoft.public.dotnet.framework.aspnet)