C# Connection String

Question

I am using the following connection string within the <configuration> node. But somehow, it seems that it is not saving. Every time I use

System.Configuration.ConfigurationManager.ConnectionStrings["myDB"].ConnectionString

it has a null value, and when I check the index "0" it points to .\SQLEXPRESS.

<connectionStrings>
   <clear/>
   <add name="myDB"
        providerName="System.Data.SqlClient"
        connectionString="Server=Server\Instance;Database=anydb;User Id=***; Password=***;" />
</connectionStrings>

The projects is an ASP.NET MVC 2 project.

I really need this to work, since I am learning the code-first Entity Framework. Is there any suggestions?

Which type of authentication you are using? sql server or windows? Database server is on separate server or not? — Amirhossein Mehrvarzi
– Amirhossein Mehrvarzi, Commented Aug 18, 2013 at 18:28
Are you sure you put <connectionStrings> section into proper config file? In case of ASP.NET MVC project it should be placed in web.config. — Eadel
– Eadel, Commented Aug 18, 2013 at 20:08

Judo · Accepted Answer · 2013-08-19 00:23:13Z

1

Things to trouble-shoot on this :

Ensure that EF is configured to use your connection string. You can do this in you DbContext class by passing the connection string name into the base constructor :
```
    public class YourContext : DbContext
{
     public YourContext()
       : base("myDB")
   {

   }
}
```
Ensure that the connection string is the correct web.config (ie in the main root not in Views)
Check that the connection string is not being overridden in the web.debug.config (or web.release.config) if it is being

answered Aug 19, 2013 at 0:23

Judo

5,2474 gold badges26 silver badges36 bronze badges

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

Collectives™ on Stack Overflow

C# Connection String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related