In last article, We talked about how to modify connection string in app.config.Continue the topic,we will introduce how to read the connection string from app.config.
主題 2.取得app.config連線內容
Subject 2.Get the connection from app.config
public SqlConnectionStringBuilder GetSQLConnectionBuilder(string m_Entities) { Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); EntityConnectionStringBuilder efb = new EntityConnectionStringBuilder( config.ConnectionStrings.ConnectionStrings[m_Entities] .ConnectionString); SqlConnectionStringBuilder sqb = new SqlConnectionStringBuilder(efb.ProviderConnectionString); return sqb; }
Example:
SqlConnectionStringBuilder sqb = new SqlConnectionStringBuilder(); sqb =GetSQLConnectionBuilder(Test_managementEntities); string dataSource = sqb.DataSource;
沒有留言:
張貼留言