Problem with connectionstrings

[desanti]

Hello ! I'm using visual studio 2013. In my app.config , there are 3 connections strings :

<connectionStrings><add name="db1Entities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=PERSONALPC\MSSQL2008R2;initial catalog=db1;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
<add name="db2Entities" connectionString="metadata=res://*/Model2.csdl|res://*/Model2.ssdl|res://*/Model2.msl;provider=System.Data.SqlClient;provider connection string="data source=PERSONALPC\MSSQL2008R2;initial catalog=db2;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
<add name="db3Entities" connectionString="metadata=res://*/Model3.csdl|res://*/Model3.ssdl|res://*/Model3.msl;provider=System.Data.SqlClient;provider connection string="data source=PERSONALPC\MSSQL2008R2;initial catalog=db3;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>

Now , I want to access these connections strings , using the following code :

Dim connstringtemplate1 As String = System.Configuration.ConfigurationManager.ConnectionStrings(1).ConnectionString.ToString

This string has "NULL" value

Dim connstringtemplate2 As String = System.Configuration.ConfigurationManager.ConnectionStrings(2).ConnectionString.ToString

This string has the first connection string

Dim connstringtemplate3 As String = System.Configuration.ConfigurationManager.ConnectionStrings(3).ConnectionString.ToString

This string has the second connection string

Dim connstringtemplate4 As String = System.Configuration.ConfigurationManager.ConnectionStrings(4).ConnectionString.ToString

This string has the third connection string Also if I use this :

Dim nr As Integer = System.Configuration.ConfigurationManager.ConnectionStrings.Count

The value of nr is 5. I have only 3 connection strings , so why there are 5 and the first is empty ? This problem appear after I have installed the Update 5 on visual studio 2013

[Mathi Mani]

Why are you getting connectionstring by index instead of getting them by using their name?

[ZurdoDev]

desanti wrote:

I have only 3 connection strings , so why there are 5 and the first is empty ?

They are probably getting merged in from the machine.config file. You can use

in .config to get rid of them. c# - ConfigurationManager.ConnectionStrings returns extra connection string from machine.config - Stack Overflow[^] But, as pointed out in the other response, the better option is to refer to them using a name rather than depending on their order.

ConfigurationManager.ConnectionStrings[connectionName].ConnectionString

There are only 10 types of people in the world, those who understand binary and those who don't.