public static string GetConnectionString(DbInfoName name) { // Assume failure. string returnValue = null; // Look for the name in the connectionStrings section. var settings = ConfigurationManager.ConnectionStrings[name.ToString()]; // If found, return the connection string. if (settings != null) { returnValue = settings.ConnectionString; } return(returnValue); }
public static void UpdateConnectionString(DbInfoName newName, string newConString, string newProviderName = "System.Data.SqlClient") { //记录该连接串是否已经存在 var isModified = ConfigurationManager.ConnectionStrings[newName.ToString()] != null; //新建一个连接字符串实例 var mySettings = new ConnectionStringSettings(newName.ToString(), newConString, newProviderName); // 打开可执行的配置文件*.exe.config var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); // 如果连接串已存在,首先删除它 if (isModified) { config.ConnectionStrings.ConnectionStrings.Remove(newName.ToString()); } // 将新的连接串添加到配置文件中. config.ConnectionStrings.ConnectionStrings.Add(mySettings); // 保存对配置文件所作的更改 config.Save(ConfigurationSaveMode.Modified); // 强制重新载入配置文件的ConnectionStrings配置节 ConfigurationManager.RefreshSection(nameof(ConfigurationManager.ConnectionStrings)); }
public void Remove(DbInfoName name) { BaseRemove(name.ToString()); }
/// <summary> /// 获取数据库配置 /// </summary> /// <param name="name">模块名称</param> /// <returns></returns> public static DbInfo GetDbInfo(DbInfoName name) { return(GetDbInfos().Find(db => db.Name == name) ?? new DbInfo()); }
/// <summary> /// 获取数据库配置 /// </summary> /// <param name="name">模块名称</param> /// <returns></returns> public static DbInfo GetDbInfo(DbInfoName name = DbInfoName.MainDb) { return(GetDbInfos()?.Find(db => db.Name == name)); }