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()
|
{
|
sqlDic.Add("YqnConn", "Data Source=192.168.0.175;Initial Catalog=HX_LimsSys;User ID=HX_USER;Password=lc@841022;Integrated Security=True");
|
//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]);//从字典取出数据库链接字符串
|
}
|
}
|
}
|
