Databases
StackOverflow2013
Postsdbo
POHow to read values from App.config in .Net 4.0 using configurationManager?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to read values from App.config in .Net 4.0 using configurationManager?
    primarykey
    data
    text
    <p>I am creating a windows service in .Net 4.0 and testing some functions of said service with a windows forms client by referencing the service project.</p> <p>The service project has an App.config file and that file looks like this: </p> <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;configuration&gt; &lt;connectionStrings&gt; &lt;clear /&gt; &lt;add name="myLocalMySQLDBUsername" connectionString="username"/&gt; &lt;/connectionStrings&gt; &lt;/configuration&gt; </code></pre> <p>When a function belonging to the service calls:</p> <ul> <li>ConfigurationManager.ConnectionStrings("myLocalMySQLDBUsername").ConnectionString </li> </ul> <p>a null reference error is thrown because my connection string is not loaded. The only connectionStrings that are loaded are from the machine.config file located in c:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\Config\machine.config</p> <p>If I create an application scope setting for the service, I can get that setting by using the My.Settings.setting -> so it's not like the App.config file is not being read.</p> <p><strong>My question is: why are my connectionStrings not being loaded from the App.config file?</strong></p> <p>Thank you for your help.</p> <p><strong>UPDATE:</strong></p> <p>Also, at this point, even a work around would be appreciated; the only reason for using app.config is to be able to encrypt the contents using the DpapiProtectedConfigurationProvider (the contents will have some username/password values for service and database connections).</p> <p>I tried creating an AppSettings section manually in the app.config but those settings were also not read by the configurationManager (count = 0).</p> <p><strong>UPDATE 2:</strong></p> <p>Per a suggestion, I tried to manually open the app.config file like so:</p> <pre><code>Dim exePath As String = System.IO.Path.Combine(Environment.CurrentDirectory, "ServiceName.exe") Dim myConfig As Configuration = ConfigurationManager.OpenExeConfiguration(exePath) </code></pre> <p>So here is the weird part, when I look inside, path is correct (points to my app.config) but the connectionStrings are still being loaded from the machine.config file (my connectionStrings are not loaded)!! ARGH</p> <p><strong>UPDATE 3:</strong></p> <p>Okay, so, I figured it out. When referencing a project(parent) from another project(child), the child's app.config is used even if the parent's classes are being used. Thus, I can get the connectionStrings to show up if I copy them over to the child's app.config. When trying to open it manually, my currentDirectory was of the child, not the parent (strange how it did not throw an exception - it wouldn't have been able to find the config file ... it just silently used the machine.config ... oh well). </p> <p><strong>Thanks all for the help!</strong></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDima
    1. USDima
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. USjust.another.programmer
      1. VTFavorite
    1. COMay be a silly question, but how do you deploy the service and its app.config? Do you have a servicename.exe.config in the correct directory?
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. USFrantišek Žiačik
    2. COI have not deployed it yet ... all is still in debugging on my local machine. When I deploy it, I will be sure that the config file ends up in the System32 folder (I think) or whatever folder that windows services look for files by default.
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. USDima
    3. COwork around posted.
      singulars
      1. POHow to read values from App.config in .Net 4.0 using configurationManager?
      1. USHogan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload