动态改变连接字符串,修改后转向新的数据库查询代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】动态改变连接字符串,修改后转向新的数据库查询

作者:Dezai.CN / 发布于2012/12/27/ 614

/// <summary>
        /// 读取数据库默认连接字符串
        /// </summary>
        /// <returns></returns>
        private string ReadDefaultConnectString()
        {
            Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            ConfigurationSection dataConfigurationSection = config.Sections["dataConfiguration"];
            string defaultDatabase = (dataConfigurationSection as Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings).DefaultDatabase;

            ConfigurationSection connectionConfigurationSection = config.Sections["connectionStrings"];
            ConnectionStringsSection connectionStringsSection = connectionConfigurationSection as ConnectionStringsSection;
            return connectionStringsSection.ConnectionStrings[defaultDatabase].ConnectionString;
        }

        /// <summary>
        /// 保存数据库默认连接字符串
        /// </summary>
        /// <param name="connectString"></param>
        private void SaveDefaultConnectString(string connectString)
        {
            Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            ConfigurationSection dataConfigurationSection = config.Sections["dataConfiguration"];
            string defaultDatabase = (dataConfigurationSection as Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings).DefaultDatabase;

            ConfigurationSection connectionConfigurationSection = config.Sections["connectionStrings"];
            ConnectionStringsSection connectionStringsSection = connectionConfigurationSection as ConnectionStringsSection;
            connectionStringsSection.ConnectionStrings[defaultDatabase].ConnectionString = connectString;
            config.Save();
        }

        /// <summary>
        /// 刷新数据库默认连接字符串
        /// </summary>
        private void RefreshConfig()
        {
            ConfigurationManager.RefreshSection("dataConfiguration");
            ConfigurationManager.RefreshSection("connectionStrings");
        }

试试其它关键字

　连接字符串　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)