CODEWITHSUNDEEP
.netdata-bindingconfigurationconnection-stringsystem.configuration
makerofthings7
makerofthings7

Reputation: 61463

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

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>

Upvotes: 0

Views: 1299

Answers (2)

franklins
franklins

Reputation: 3738

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

Upvotes: 0

Tony Abrams
Tony Abrams

Reputation: 4673

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

Upvotes: 2

Related Questions