Click here to Skip to main content
13,143,185 members (35,388 online)


QuestionC# issue: connection string to app.config file Pin
rachel_m10-Nov-12 8:05
memberrachel_m10-Nov-12 8:05 
In a C# 2008 application, I used linq to sql to connect to a sql server 2008 database. Now I want to obtain the connection of the database from the
app.config file instead of hardcoding the value into the application. I want to be able to change the connection string to the database since I will be moving this application from unit testing database to user acceptance database to the the prodction database.

Right now I am getting the error message, ""Object reference not set to an instance of an object." I know this error message is coming from the line of code that I listed below since it is the only line of code I changed.

The following is a snippet of the code from the *.designer.cs file (this is part of the dbml file).
using System.Configuration;
public esampleDataContext() : 
**Note:  base(global::sample.Properties.Settings.Default.DEVConnectionString, mappingSource) is the line of code that I replaced that was generated by the
         .net framework

I want to mention the following:
1. The *.dbml file is associated with a particular project file.
2. The connection string settings for this *.dbml file are the following:
a. DEVConnectionString (settings)
b. Connection String = Data Source=dev1;Initial Catalog=DEV_test;Integrated Security=True
c. application settings=True
d. settings property name is DEVConnectionString.
3. The project file that has the *.dbml file. has a reference set to the system.configuration.

**Note: This code in similar applications that I wrote, but I do not why it does not work here.

Thus can you tell me, show me in code, and/or point me to a reference that I can use so I can obtain the value in the app.config file for the database connection string I want to use. I do not want to use a hard-coded connection string to the database.
AnswerRe: C# issue: connection string to app.config file Pin
Eddy Vluggen10-Nov-12 23:38
memberEddy Vluggen10-Nov-12 23:38 
GeneralRe: C# issue: connection string to app.config file Pin
rachel_m11-Nov-12 6:11
memberrachel_m11-Nov-12 6:11 
AnswerRe: C# issue: connection string to app.config file Pin
jschell11-Nov-12 10:39
memberjschell11-Nov-12 10:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy |
Web03 | 2.8.170915.1 | Last Updated 21 Sep 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid