Getting connection string from App.config and using it in a Linq dataContext

Question

How should I extract the following connection string and apply it to my Linq context? I know the Linq portion, but am weak with the System.Configuration section.

  <connectionStrings>
        <!-- Production

        <add name="Management_Report_Emailer.Properties.Settings.DWConnectionString"
            connectionString="Data Source=prodSQL01;Initial Catalog=DW;Integrated Security=True"
            providerName="System.Data.SqlClient" />-->


      <!-- QA-->

      <add name="Management_Report_Emailer.Properties.Settings.DWConnectionString"
            connectionString="Data Source=qaSQL01;Initial Catalog=DW;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>

Tony Abrams · Accepted Answer · 2011-01-13 17:59:28Z

2

ConfigurationManager.ConnectionStrings("Management_Report_Emailer.Properties.Settings.DWConnectionString").ConnectionString

answered Jan 13, 2011 at 17:59

Tony Abrams

4,6613 gold badges27 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

makerofthings7 Over a year ago

Works for me, just had to replace parens, with brackets. Thanks!

Tony Abrams Over a year ago

Yeah, I didn't see anything talking about VB/C# so I just put it in the VB way.

franklins · Accepted Answer · 2011-01-13 18:05:29Z

0

ConfigurationManager.ConnectionStrings["Management_Report_Emailer.Properties.Settings.DWConnectionString"].ConnectionString;

answered Jan 13, 2011 at 18:05

franklins

3,7686 gold badges43 silver badges56 bronze badges

Collectives™ on Stack Overflow

Getting connection string from App.config and using it in a Linq dataContext

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related