ConfigurationSettings.AppSettings["value"] returns a string that starts with '@'

[lauralucas]

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSettings.AppSettings["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySelectQuery);
myCommand.Connection = new SqlConnection(myConnectString);
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas

[lauralucas]

now that I look at it, the at-sign is not part of the string, look at
this picture:

http://i7.tinypic.com/20tgj08.jpg

weird, what does it mean?
la********@gmail.com wrote:

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSettings.AppSettings["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySelectQuery);
myCommand.Connection = new SqlConnection(myConnectString);
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas

[lauralucas]

the answer:

It means that any backslash characters displayed aren't used for escape
purposes. For instance:

@"hello\tworld" is hello backslash tworld
whereas
"hello\tworld" is hello tab world

thanks

la********@gmail.com wrote:

now that I look at it, the at-sign is not part of the string, look at
this picture:

http://i7.tinypic.com/20tgj08.jpg

weird, what does it mean?
la********@gmail.com wrote:

Hello

I'm trying to use a connection string stored in web.config

here is the web.config part

<appSettings>
<add key="NDDbase"
value="Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"/>
</appSettings>

and from code I'm trying to access it like this:

string mySelectQuery = "SELECT * FROM sometable'";
string myConnectString = ConfigurationSettings.AppSettings["NDDbase"];

SqlCommand myCommand = new SqlCommand(mySelectQuery);
myCommand.Connection = new SqlConnection(myConnectString);
But when debugging, I see that myConnectString value always starts with
an @, like this:
@"Server=SOMESERVER\\SOMEINSTANCE;integrated
security=SSPI;database=NDD"

is this normal? I could parse the string and remove the at-sign but I
suppose is there for a reason. This makes the SqlConnection to not
open, as it is not initialized properly.

help me and write me some suggestions please, thanks =)

Regards
Laura Lucas