[C#]Entity Frame Work Connection String Modify and Read in App.config Part.2

延續上篇文章提到的修改app.config，這邊主要簡略的介紹如何讀取app.config的連接字串
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;