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));
}
