Hi there,

I wish to remove the connection strings from my web.config, and setting them programmatically. This works just fine, but there's that sqlCacheDependency (under 'caching') section which gives me a headache. It requires a connection string name within the web.config to operate.

Moreover, I have the 'roleManager' and 'membership' elements that too need the connection string name in thier attributes.

I've tried getting a reference to the sqlCacheDependency object in order to change it's connection string value programmatically, but couldn't.

Can anyone think of a way this can be possible ? I've even started thinking of removing it from the web.config and create a static object for this kind of caching ..

Hi,

Can you not change existing web.confi connection string programatically?

Alternatively, Remove all configurations ( SQLCacheDependency, RolManager, Membership etc those are using connection string ) from web.config, and programatically configure them (for example in Application Start Event). Although it would not be a recommended way , but it might suits you in current situation.

Thank You

Muhammad Akhtar Shiekh

For the SqlCacheDependcy part of your question, do this from your Global.asax:

protected void Application_Start(object sender, EventArgs ev)
{
    SqlDependency.Start("your conn str");
}

protected void Application_Stop(object sender, EventArgs e)
{
     SqlDependency.Stop("your conn str");
}

SqlCacheDependency uses the same infrastructure as SqlDependency.

You can remove the SQL cache dependency from your web.config.  If you do that you'll have to ensure that you don't have code that is relying on it though.