How to retrieve the connection string from App.config from another project?

Question

How to retrieve the connection string from App.config from another project?

Navigation

#1 by (1 votes)
#2 by (0 votes)

0

I have these connection strings in App.config from another project :

<connectionStrings>
   <add name="ConexaoTeste1" 
    connectionString="RGF0YSBTb3VyY2U9JCQkXFNRTEVYUFJFU1M7SW5pdGlhbCBDYXRhbG9nPXRlc3RlOw==" 
    providerName="System.Data.SqlClient"/>

   <add name="ConexaoTeste2" 
    connectionString="RGF0YSBTb3VyY2U9dGVzdGU7UGVyc2lzdCBTZWN1cml0eSBJbmZvPVRydWU7" 
    providerName="System.Data.OracleClient"/>
</connectionStrings>

This other project is not on my computer. It's in the network.

How do I redeem the value of ConexaoTeste2 in my project ?

c# app.config

asked by anonymous 23.03.2017 / 13:00

2 answers

How to display HTML elements in an Android TextView? How to create relationship tables 1: N?

score 1 · Answer 1

Add reference System.Configuration to your project and do:

string conexao = 
    System.Configuration.ConfigurationManager.
    ConnectionStrings["ConexaoTeste2"].ConnectionString;

About the fact that App.config is remote: Here has a good reason not to do so, and also have some alternatives.

score 0 · Answer 2

I was able to solve the problem with the code below, ignoring the file as config and treating it as a normal xml, I ran the document, found the node that needed to change and worked:

XmlDocument xml = new XmlDocument();
xml.Load("\server\configs\teste.exe.config");
xml.SelectNodes("configuration/connectionStrings/add").Item(1).Attributes["connectionString"].Value = "foi";
xml.Save("\server\configs\teste.exe.config");