我有一个包含包含一个连接字符串,应用程序配置文件控制台应用程序如下图所示:
I have a console app containing an application configuration file containing one connection string as shown below:
<configuration> <connectionStrings> <add name="Target" connectionString="server=MYSERVER; Database=MYDB; Integrated Security=SSPI;" /> </connectionStrings> </configuration>当我使用它传递给我的连接方式:
When I pass this to my Connection using:
ConfigurationManager.ConnectionStrings[1].ToString()我有两个值在那里,因此使用集合中的第二个,我的问题是,什么是第二次来的?
I have two values in there, hence using the second in the collection, my question is where is this second coming from?
我已经检查了\\ BIN的版本和原来和我无关!它显然是一个系统生成的一个,但我还没有见过这个?任何人都可以告诉我吗?
I have checked the \Bin version and original and its not mine! Its obviously a system generated one but I have not seen this before? Can anyone enlighten me?
神秘的连接字符串是:
data source=.\SQLEXPRESS; Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf; User Instance=true这是不是一个问题,因为这样我只是想知道这是为什么出现?在此先感谢!
This isn't a problem as such I would just like to know why this is occuring? Thanks in advance!
有关备查那些谁可能会或可能不会在这个绊倒,发现了的machine.config ,它变得很明显这是不好的做法,通过指一个配置后,其作为每个堆栈索引将可能是不同的,这就是为什么密钥被使用。
For future reference to those who may or may not stumble on this, after discovering the machine.config, it's become apparent it is bad practice to refer to a config by its index as each stack will potentially be different, which is why "Keys" are used.
在这种情况下我的code将是:
In this instance my code would be:
ConfigurationManager.ConnectionStrings["Target"].ToString()干杯所有!
推荐答案检查的machine.config 。如果你只想要你进入,你可以添加一个&LT;清/&GT; 元素添加到&LT;是connectionStrings&GT; 像这样的元素...
Check your machine.config. If you only want your entry, you can add a <clear /> element to the <connectionStrings> element like so ...
<connectionStrings> <clear /> <add name="Target" connectionString= "server=MYSERVER; Database=MYDB; Integrated Security=SSPI;" /> </connectionStrings>更多推荐
C#配置管理器。的ConnectionStrings
发布评论