配置webAsp数据库以及获取的方法（dalBase）

在 节点下 新增

<connectionStrings>
    <add name="DefaultConnection"
      connectionString="Data Source=test.anssy.com;Initial Catalog=dwzxws; User Id = Snasy; Password =Snasy#895;Connect Timeout=2"
      providerName="System.Data.SqlClient"/>
  </connectionStrings> 

后台获取的方法为：

public IDbConnection DALBaseConn()
            {
                IDbConnection conn = null;
                
                    string defaultcon =  ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
                //defaultcon = $"Data Source ={linkModel.DBAdd}; Initial Catalog ={linkModel.DBName}; User Id = {linkModel.DBUser}; Password ={linkModel.DBPwd}";
                    try
                    {
                        conn = new SqlConnection(defaultcon);
                        conn.Open();

                    }
                    catch (Exception ex)
                    {
                        string ErrMsg = string.Format("sql数据库连接错误，错误原因是:{0}", ex.Message);
                        Common.LogWrite.WriteLog(ErrMsg);
                        conn = null;
                        //throw new Exception(ErrMsg);
                    }
             
                return conn;
            }