blocks|key|1427659|text|你可以从ConfigurationManager.AppSettings中读取连接字符串值，是的，它是只读的。您可以在App.Config中更改它。如果你想改变连接字符串中的一些值，对于ex，你可以在代码中改变你的dataContext.URL或者任何你想要的编码属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1427660|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can read Connection String Value from ConfigurationManager.AppSettings, yes it is readonly. You can change it in App.Config.
If you want to change some values in connection string, for ex URL, in code you can change your dataContext.URL or any properties you want with coding.

blocks|key|2324627|text|我认为对于单元测试来说，这可能要容易得多。您可以将连接字符串作为硬编码字符串直接放入测试类中。在简单的单元测试中，您测试有限的逻辑范围，而不关心输入参数的真实性|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2324628|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I think for unit tests it may be much easy. you may put connection string into a test class directly as hardcoded string. in simple unit tests you test limited logic scope and not care of authentically of input arguments

blocks|key|2324662|text|使用反射，您可以(在内存中)更改Configuration.ConnectionStringsconnectionName，的值，在这种情况下，您可能会在SetUp或TestFixtureSetUp中执行此操作。参见http://david.gardiner.net.au/2008/09/programmatically-setting.html。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2324663|//+Back+up+the+existing+connection+string
ConnectionStringSettings+connStringSettings+=+ConfigurationManager.ConnectionStrings[connectionName];
string+oldConnectionString+=+connStringSettings.ConnectionString;

//+Override+the+IsReadOnly+method+on+the+ConnectionStringsSection.
//+This+is+something+of+a+hack,+but+will+work+as+long+as+Microsoft+doesn't+change+the
//+internals+of+the+ConfigurationElement+class.
FieldInfo+fi+=+typeof(ConfigurationElement).GetField("_bReadOnly",+BindingFlags.Instance+%7C+BindingFlags.NonPublic);
fi.SetValue(connStringSettings,+false);

//+Set+the+new+connection+string+value
connStringSettings.ConnectionString+=+connectionStringNeededForNUnitTest;|code-block|syntax|javascript|2324664|entityMap|0|LINK|mutability|MUTABLE|url|http://david.gardiner.net.au/2008/09/programmatically-setting.html^0|30|1U|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Using reflection, you can (in memory) change your value of the Configuration.ConnectionStrings[connectionName], which in your case you would probably do in SetUp or perhaps TestFixtureSetUp. See <a href="http://david.gardiner.net.au/2008/09/programmatically-setting.html" rel="noreferrer">http://david.gardiner.net.au/2008/09/programmatically-setting.html</a>.

<pre><code>// Back up the existing connection string
ConnectionStringSettings connStringSettings = ConfigurationManager.ConnectionStrings[connectionName];
string oldConnectionString = connStringSettings.ConnectionString;

// Override the IsReadOnly method on the ConnectionStringsSection.
// This is something of a hack, but will work as long as Microsoft doesn't change the
// internals of the ConfigurationElement class.
FieldInfo fi = typeof(ConfigurationElement).GetField("_bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);
fi.SetValue(connStringSettings, false);

// Set the new connection string value
connStringSettings.ConnectionString = connectionStringNeededForNUnitTest;
</code></pre>

blocks|key|3731871|text|我知道这不是你要找的答案，但这是我用来解决你同样问题的答案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3731872|您至少可以在EF5和EF4.3中修改您的DbContext实现，并添加接受硬编码连接字符串的构造函数，如下所示：|3731873|++++public+partial+class+MyContext+:+DbContext
++++{
++++++++public+MyContext()+:+base("name=MyContext")
++++++++{
++++++++}
++++++++//+---+Here+is+the+new+thing:
++++++++public+MyContext(string+entityConnectionString)+:+base(entityConnectionString)
++++++++{
++++++++}
++++++++//+---+New+thing+ends+here

++++++++//+....+the+rest+of+the+dbcontext+implementation+follows+below+
++++}+|code-block|syntax|javascript|3731874|每次重新生成上下文时，您都必须粘贴此内容，但我认为这是值得的。连接字符串必须是使用元数据和所有内容格式化的实体框架，但您将能够弄清楚它。把它放在某个地方，这样你就可以在需要的时候把它粘贴进去。|3731875|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I realize this is not the answer you are looking for, but it is the one I applied to solve your same problem:

You can modify, in EF5 and EF4.3 at least, your DbContext implementation and add a constructor that accepts a hard coded connection string, such as this: 

<pre><code> public partial class MyContext : DbContext
 {
 public MyContext() : base("name=MyContext")
 {
 }
 // --- Here is the new thing:
 public MyContext(string entityConnectionString) : base(entityConnectionString)
 {
 }
 // --- New thing ends here

 // .... the rest of the dbcontext implementation follows below 
 } 
</code></pre>

You would have to paste this thing in every time you regenerate your context, but IMHO it's worth the hassle. The connection string has to be entity framework formatted with your metadata and everything, but you will be able to figure it out. Just keep it somewhere so you can paste it in whenever necessary.

we use the nunit.exe application to run our (integration)test

Now i experience the problem that the connectionstring is not picked up from the app.config from the dll where the testcode is in.

That sounds logical because the nunit.exe is the starting app and not the test dll (it used to work when i started the tests from the visual studio testframework by the way), but should i put the connectionstrings in the nunit.exe.config?

I tried setting them in the testcode (works for the appsettings : <code>ConfigurationManager.AppSettings.Set("DownloadDirectory", mDir);)</code> like this:
<code>ConfigurationManager.ConnectionStrings.Add(conset);</code> (where <code>conset</code> is a <code>ConnectionStringSettings</code> object), but then i get the error that the connectionstrings section is readonly.

What should i do to use the connectionstrings in my test?

EDIT:
we use the entity framework so we can't put the connectionstring in the appsettings because it reads from the section directly, i couldn't find a way to work around this behaviour.

Using the connectionstring in an nunit test

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我们使用nunit.exe应用程序来运行(集成)测试现在我遇到了这样的问题:连接字符串没有从测试代码所在的dll的app.config中提取。这听起来合乎逻辑，因为nunit.exe是启动应用程序，而不是测试dll (顺便说一下，当我从visual studio testframework启动测试时，它可以工作)，但是...

问在nunit测试中使用connectionstring
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在nunit测试中使用connectionstringEN