asp.net – MembershipProvider在代码中更改连接字符串

<membership defaultProvider="SqlProvider" ...>
  <providers>
    <add name="SqlProvider" type="System.Web.Security.SqlMembershipProvider"
         connectionStringName="MyConnectionStringName" 
         .../>
  </providers>
</membership>

您可以直接指定连接字符串：

<membership defaultProvider="SqlProvider" ...>
  <providers>
    <add name="SqlProvider" type="System.Web.Security.SqlMembershipProvider"
         connectionString="data source=... " 
         .../>
  </providers>
</membership>

因此,您还可以从SqlMembershipProvider派生自定义提供程序,并按如下方式动态构建连接字符串：

public class MySqlMembershipProvider : SqlMembershipProvider
{
    public override void Initialize(string name,NameValueCollection config)
    {
        config["connectionString"] = BuildMyCustomConnectionString();
        base.Initialize(name,config);
    }
}