using System;
|
using System.Collections.Generic;
|
using System.Configuration;
|
using System.Linq;
|
using System.Web;
|
|
namespace WebAPI.Dapper
|
{
|
public class SqlPools
|
{
|
public SqlPools()
|
{
|
SecConnStr();
|
}
|
static Dictionary<string, string> sqlDic = new Dictionary<string, string>();
|
/// <summary>
|
/// 将配置文件夹中的数据库链接全部遍历至字典
|
/// </summary>
|
private void SecConnStr()
|
{
|
ConnectionStringSettingsCollection seetings = ConfigurationManager.ConnectionStrings;//获取配置文件connectionstring所有节点
|
for (int i = 0; i < seetings.Count; i++)
|
{
|
sqlDic.Add(seetings[i].Name, seetings[i].ConnectionString);//存入字典
|
}
|
}
|
/// <summary>
|
/// sqlhelper实例化
|
/// </summary>
|
/// <param name="dbName"></param>
|
/// <returns></returns>
|
public static SqlHelper GetInstance(string dbName)
|
{
|
return new SqlHelper(sqlDic[dbName]);//从字典取出数据库链接字符串
|
}
|
}
|
}
|
