ConfigurationManager.ConnectionStrings从machine.config返回额外的连接字符串 [英] ConfigurationManager.ConnectionStrings returns extra connection string from machine.config
问题描述
我在写一个windows服务,我需要在App.config中定义的所有连接字符串的列表。
I'm writing a windows service and I need the list of all connection strings defined in App.config.
我使用System.Configuration.ConfigurationManager.ConnectionStrings获取所有连接。
I Used System.Configuration.ConfigurationManager.ConnectionStrings to get all connections.
它总是返回此额外连接:
it always return this extra connection:
data source = .\SQLEXPRESS;集成Security = SSPI; AttachDBFilename = | DataDirectory | aspnetdb.mdf; User Instance = true
data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
我认为是在machine.config中添加
that I think is added in machine.config.
my App.config is:
my App.config is:
<add name="AvmPortalConnectionString"
connectionString="Data Source=.;Initial Catalog=AvmPortal;Integrated Security=True"
providerName="System.Data.SqlClient" />
get only connection App.config中定义的字符串(而不是machine.config中的字符)
Is there anyway that I can get only connection Strings defined in App.config(not the one in machine.config)
我可以删除这个,但是我想知道是否有更简洁的方法!
I can remove this, but I wonder if there is a cleaner way!
感谢
推荐答案
尝试在添加之前添加清除: / p>
Try adding a clear before the add:
<connectionStrings>
<clear />
<add name="AvmPortalConnectionString"
connectionString="Data Source=.;Initial Catalog=AvmPortal;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
这篇关于ConfigurationManager.ConnectionStrings从machine.config返回额外的连接字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!