EF DataBase First 动态拼接数据库连接

 /// <summary>
        /// EF DataBase First 动态拼接数据库连接
        /// </summary>
        /// <param name="edmxFullName">创建EF实体时的命名（也是数据库实体名称）</param>
        /// <param name="connectionStringName">连接字符串的名称</param>
        /// <returns>返回解密后的链接字符串</returns>
        public static string EFDecryptDESConnectionString(string edmxFullName,string connectionStringName)
        {
            //dbConnectionString是自定义变量，不用在意
            if (!dbConnectionString.Keys.Any(o => o == connectionStringName))
            {
                string DESConnectionString = DecryptDES(ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString, CONNECTIONSTRINGDESKEY);
                string[] DESConnectionStringArr = DESConnectionString.Split('|');
                //以下是主要部分，这里开始才是重点，连接字符串是以“|”分割保存在配置文件中的
                System.Data.EntityClient.EntityConnectionStringBuilder entityConnectionStringBuilder = new System.Data.EntityClient.EntityConnectionStringBuilder();
                entityConnectionStringBuilder.Metadata = "res://*/" + edmxFullName + ".csdl|res://*/" + edmxFullName + ".ssdl|res://*/" + edmxFullName + ".msl";
                entityConnectionStringBuilder.Provider = "System.Data.SqlClient";

                SqlConnectionStringBuilder sqlConnectionStringBuilder = new SqlConnectionStringBuilder();
                sqlConnectionStringBuilder.DataSource = DESConnectionStringArr[0];
                sqlConnectionStringBuilder.InitialCatalog = DESConnectionStringArr[1];
                sqlConnectionStringBuilder.IntegratedSecurity = false;
                sqlConnectionStringBuilder.UserID = DESConnectionStringArr[2];
                sqlConnectionStringBuilder.Password = DESConnectionStringArr[3];
                sqlConnectionStringBuilder.MultipleActiveResultSets = true;
                sqlConnectionStringBuilder.ApplicationName = "EntityFramework"";
                entityConnectionStringBuilder.ProviderConnectionString = sqlConnectionStringBuilder.ToString();
                dbConnectionString.Add(connectionStringName, entityConnectionStringBuilder.ConnectionString);
            }
            return dbConnectionString[connectionStringName];
        }