微软企业库的使用

1、config里面配置
  < configuration > 
    <connectionStrings> 
    <add name="name" connectionString="Data Source = ***;Network Library=DBMSSOCN; Initial Catalog = ***; User ID = ***; Password = ***" providerName="System.Data.SqlClient"/>
  </connectionStrings>
 </ configuration >


 C#后台代码：
   Database db = DatabaseFactory.CreateDatabase("name");//创建数据库实例
   string sql = @"select * from table where username=@username";
   DbCommand cmd = db.GetSqlStringCommand(sql);
   db.AddInParameter(cmd, "username", DbType.String, username);
   DataTable dt = db.ExecuteDataSet(cmd).Tables[0];


2、自定义链接字符串
   
    string ABC = "***";
    string strServerName = GetWebConfigValue("DBServerName");
    SqlDatabase db = new SqlDatabase("data source=" + strServerName + ";initial catalog=***;persist security info=False;user id=***;pwd=" + ABC);//创建数据库实例
    string sql = @"select * from table where username=@username";
    DbCommand cmd = db.GetSqlStringCommand(sql);
    db.AddInParameter(cmd, "username", DbType.String, username);
    DataTable dt = db.ExecuteDataSet(cmd).Tables[0];


  //获取配置中的服务器地址
        public string GetWebConfigValue(string sPara)
        {
            string sValue = "";
            try
            {
                sValue = System.Configuration.ConfigurationSettings.AppSettings[sPara].ToString().Trim();
            }
            catch
            {
                sValue = "(local)";
            }
            return sValue;
        }