Hi,
I develop an asp.net web application and I use ASP.NET membership provider. The application uses the membership schema and all required objects inside main application database
However, during development I have
to switch
to various databases, for different development and testing scenarios. For this I have an external connection strings section file and also an external appsettings section, which allow me
to not change main web.config but switch the db easily, by changing setting only in appsettings section.
My files are as below:
<connectionStrings configSource="connections.config">
</connectionStrings>
<appSettings file="
local.config">
....
ConnectionStrings looks as usual:
<connectionStrings>
<add name="MyDB1" connectionString="..." ... />
<add name="MyDB2" connectionString="..." ... />
....
</connectionStrings>
And
local.config as below
<appSettings>
<add key="ConnectionString" value="MyDB2" />
My code takes into account
to use this connection string
But membership settings in web.config contains the connection string name directly into the setting, like
<add name="MembershipProvider" connectionStringName="MyDB2" ...>
....
<add name="RoleProvider" connectionStringName="MyDB2" ...>
Because of this, every time I have
to edit them too
to use the new db.
Is there any way
to config membership provider
to use an appsetting
to select db connection for membership db? Or
to "redirect" it
to read connection setting from somewhere else? Or at least
to have this in some external file (like
local.config)
Maybe is some easy way
to wrap asp.net membership provider intio my own provider which will just read connection string from where I want and pass it
to original membership provider, and then just delegate the whole membership functionality
to asp.net membership provider.
Thanks.
