Connection strings and configuration manager

Question

I have a project by someone else and there is this line of code:

ConnectionStringSettings myConnectionStringSetting = ConfigurationManager.ConnectionStrings[0];

which for some reason returns this:

ConfigurationManager.ConnectionStrings[0] is returning {data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true}                System.Configuration.ConnectionStringSettings

I don't have selexpress installed to my knowledge and my web.config points to my server using a different connection string. Where do I find the list of all the connection strings in VS 2010?

Doing an find on the entire solution returns no results for sql express either.

Nudier Mena · Accepted Answer · 2013-09-21 04:14:57Z

4

Just try to insert an <clear/> tag before your ConnectionsString.

 <connectionStrings>
  <clear/>
  <!--You connectionString go here-->
 </connectionStrings>

answered Sep 21, 2013 at 4:14

Nudier Mena

3,2842 gold badges25 silver badges22 bronze badges

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

2 Comments

cdub Over a year ago

Is that what clear does? It cleans all the connection strings and makes connectionstring["0"] be the one right after clear?

Nudier Mena Over a year ago

@chris The clear tag clean the default connectionString which is : source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true

Valery Petrov · Accepted Answer · 2013-09-21 03:04:57Z

0

About Connection Strings and Configuration Files

About Connection Strings & the Web.config File

Example from MSDN:

System.Configuration.Configuration rootWebConfig =
            System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
        System.Configuration.ConnectionStringSettings connString;
        if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
        {
            connString =
                rootWebConfig.ConnectionStrings.ConnectionStrings["NorthwindConnectionString"];
            if (connString != null)
                Console.WriteLine("Northwind connection string = \"{0}\"",
                    connString.ConnectionString);
            else
                Console.WriteLine("No Northwind connection string");
        }

edited Sep 21, 2013 at 3:04

answered Sep 21, 2013 at 0:04

Valery Petrov

6837 silver badges19 bronze badges

3 Comments

Steve Over a year ago

Sorry, but you should know that a link only answer is not considered a good answer also if the link contains the answer for the OP. Links die and your answer becomes useless to future readers. Try to elaborate or just write a comment.

cdub Over a year ago

The problem is I have a SQLEXPRESS connection string when I debug but it appears no where in the solution or in the web.config. The web.config is the correct one.

Valery Petrov Over a year ago

It's much pretty to use name as key to access it: ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings[name]; Also you may look this question link

Collectives™ on Stack Overflow

Connection strings and configuration manager

2 Answers 2

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related