Elmah SQL Server 動態建立連線字串
專案名稱: Project1
在Project1裡建立檔案:TestLog1.cs
namespace Project1
{
public class TestLog1 : Elmah.SqlErrorLog
{
public override string ConnectionString
{
get {
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = '伺服器名稱';
sqlBuilder.InitialCatalog = '資料庫名稱';
sqlBuilder.UserID = '帳號';
sqlBuilder.Password = '密碼';
return sqlBuilder.ToString() ;
}
}
}
}
Web.config內的要有Elmah假的設定資料庫連線字串
<add name="TestEntities" connectionString="Data Source=;User ID=;Password=;Initial Catalog=;" providerName="System.Data.SqlClient" />
檔案:Web.config
<elmah>
<errorLog type="Project1.TestLog1, Project1" connectionStringName="TestEntities" />
</elmah>
在Project1裡建立檔案:TestLog1.cs
namespace Project1
{
public class TestLog1 : Elmah.SqlErrorLog
{
public override string ConnectionString
{
get {
SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
sqlBuilder.DataSource = '伺服器名稱';
sqlBuilder.InitialCatalog = '資料庫名稱';
sqlBuilder.UserID = '帳號';
sqlBuilder.Password = '密碼';
return sqlBuilder.ToString() ;
}
}
}
}
Web.config內的要有Elmah假的設定資料庫連線字串
<add name="TestEntities" connectionString="Data Source=;User ID=;Password=;Initial Catalog=;" providerName="System.Data.SqlClient" />
檔案:Web.config
<elmah>
<errorLog type="Project1.TestLog1, Project1" connectionStringName="TestEntities" />
</elmah>
留言
張貼留言