entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://docs.microsoft.com/en-us/dotnet/api/system.environment.getenvironmentvariable?view=netframework-4.8|blocks|key|6jagf|text|将连接字符串作为环境变量存储在每台PC上。|unstyled|depth|inlineStyleRanges|entityRanges|egiij|创建到数据库的连接时，请改用Environment.GetEnvironmentVariable方法检索连接字符串。|offset|length|4gmas^0|0|E|Y|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|N|G|@]|H|@]|6|$]]|$A|I|C|J|2|E|F|O|G|@]|H|@$K|P|L|Q|A|R]]|6|$]]|$A|M|C|-4|2|E|F|S|G|@]|H|@]|6|$]]]]

Store the connection string as an environment variable on each PC.

When creating the connection to the database, retrieve the connection string using <a href="https://docs.microsoft.com/en-us/dotnet/api/system.environment.getenvironmentvariable?view=netframework-4.8" rel="nofollow noreferrer">Environment.GetEnvironmentVariable</a> method instead.

entityMap|blocks|key|agkf9|text|(在编写本文时，还没有代码)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|46omk|这就是appsettings.json+(或它的对等物)诞生的目的。|7aiu9|据我所知，您的困境(您需要在您的写作中使用更多的空格以使其更容易阅读)，您基本上是在两个不同的环境中工作(类似于dev和test)。简单的配置更改将是最简单的方法。|e46j2|顺便说一句:从字里行间看，你似乎是在硬编码连接字符串，我有一个两个字的建议给你:停止它！(我过去经常这样做，这是一个很难改掉的坏习惯)|1a0vv^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|K|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|L|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|M|9|@]|A|@]|B|$]]|$2|I|4|-4|6|7|8|N|9|@]|A|@]|B|$]]]]

(at time of writing, there's no code)

This is what appsettings.json, (or it's counterparts), was made for.

As i perceive your predicament, (you need more whitespace in your writing to make it easier to read), you are basically working in two different environments, (similar to dev versus test). A simple configuration change would be the simplest way.

As an aside:
Reading between the lines, it seems like you are hard-coding connection strings, and I have a two-word advice for you: STOP IT! (I used to do that, and It's a bad habit that can be hard to shake off)

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://joonasw.net/view/asp-net-core-1-configuration-deep-dive|blocks|key|bolc0|text|如果您使用的是aspnet核心，有一种方法可以将环境变量配置为应用程序设置的覆盖。这样，您将拥有一个包含所有常用设置的“默认”appsettings.json，然后在不同的计算机上，您可以配置环境变量，以不同的方式替换(覆盖)每台计算机的连接字符串|unstyled|depth|inlineStyleRanges|entityRanges|8s5hj|我认为对于整个框架的aspnet也可以采用类似的方法。|8uitc|由于您的连接字符串已经有了一个非常具体的名称"dbShubertEntities“，因此覆盖它应该是非常有效的，并且您不应该冒着在处理不同项目的情况下发生连接字符串冲突的风险。|3neh5|作为参考，请参阅使用.AddEnvironmentVariables()的部分的https://joonasw.net/view/asp-net-core-1-configuration-deep-dive|offset|length|7redr^0|0|0|0|14|1R|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|R|G|@]|H|@]|6|$]]|$A|I|C|J|2|E|F|S|G|@]|H|@]|6|$]]|$A|K|C|L|2|E|F|T|G|@]|H|@]|6|$]]|$A|M|C|N|2|E|F|U|G|@]|H|@$O|V|P|W|A|X]]|6|$]]|$A|Q|C|-4|2|E|F|Y|G|@]|H|@]|6|$]]]]

if you are using aspnet core there is a way to configure environment variable as override for the app settings
this way you'll have a "default" appsettings.json that contains all the common settings, then on the different machine you can configure environmnet variables that replaces (override) the connection string in different way for each machine

i suppose a similar approach is possible for aspnet for the full framework as well

as your connection string have already a quite specific name "dbShubertEntities" it sould be quite effective to override and you should not risk to have connection string collisions in case you work on different projects.

as reference see <a href="https://joonasw.net/view/asp-net-core-1-configuration-deep-dive" rel="nofollow noreferrer">https://joonasw.net/view/asp-net-core-1-configuration-deep-dive</a> the part where it uses .AddEnvironmentVariables()

entityMap|blocks|key|9bhco|text|您可以用动态连接字符串重载DbContext的构造函数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|cn9g0|public+class+MasterDal+:+DbContext
++++{
++++++++public+MasterDal(string+nameOrConnectionString)+:+base(nameOrConnectionString)
++++++++{

++++++++}
+++++++//+DbSet+&++OnModelCreating+etc+
++++}|code-block|syntax|javascript|bur0s|然后根据需要在控制器中调用dal+|c6f1f|if+(logicToGetPc.equal("CEI"))
+{+
++++MasterDal+dal+=+new+MasterDal("dbShubertEntitiesCEI");
+++//+do++mumbai+related+whatever+
+}
+else+if+(logicToGetPc.equal("Laptop"))
+{
+++++MasterDal+dal+=+new+MasterDal("dbShubertEntitiesCEILaptop");
+}|aq6nt^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|N|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|O|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|P|9|@]|A|@]|B|$F|G]]|$2|L|4|-4|6|7|8|Q|9|@]|A|@]|B|$]]]]

You could overload the DbContext's constructor with the dynamic connection string

<pre><code>public class MasterDal : DbContext
 {
 public MasterDal(string nameOrConnectionString) : base(nameOrConnectionString)
 {

 }
 // DbSet &amp; OnModelCreating etc 
 }
</code></pre>

&amp; then invoke dal in Controller as required

<pre><code>if (logicToGetPc.equal("CEI"))
 { 
 MasterDal dal = new MasterDal("dbShubertEntitiesCEI");
 // do mumbai related whatever 
 }
 else if (logicToGetPc.equal("Laptop"))
 {
 MasterDal dal = new MasterDal("dbShubertEntitiesCEILaptop");
 }
</code></pre>

I am currently working on an <code>ASP.NET</code> <code>MVC</code> project with <code>Entity Framework</code>. The solution includes the <code>ASP.NET</code> <code>MVC</code> application and a <code>DataProvider</code> project. The project only includes an <code>EF</code> model, as I have a partner who shares a database with me. 

The problem is in that, that we don't actually share the same database. What I mean is that the actual server of the database is not the same. We have the same tables. But the connection string has to be changed every single time we pull from our <code>git</code> repository. The string changes in the <code>web.config</code> file of the <code>ASP.NET</code> <code>MVC</code> project and in the <code>app.config</code> file of the <code>EF</code> library.

My question is - if there is a way for our system to detect which <code>PC</code> it is running on and modify the connection string dynamically? Now I do it manually.

<pre><code>&lt;!--PC NICO CEI--&gt;

&lt;!--
&lt;connectionStrings&gt;
 &lt;add name="dbShubertEntities" 
 connectionString="metadata=res://*/ModelDbShubert.csdl|res://*/ModelDbShubert.ssdl|res://*/ModelDbShubert.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=E04\SQLEXPRESS;initial catalog=dbShubert;user id=gereisma17;password=12321;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" 
 providerName="System.Data.EntityClient" /&gt;
&lt;/connectionStrings&gt;
--&gt;

&lt;!--PC NICO Laptop--&gt;

&lt;!--
&lt;connectionStrings&gt;
 &lt;add name="dbShubertEntities" 
 connectionString="metadata=res://*/ModelDbShubert.csdl|res://*/ModelDbShubert.ssdl|res://*/ModelDbShubert.msl;provider=System.Data.SqlClient;provider connection string=&amp;quot;data source=DESKTOP-I62BLOC;initial catalog=dbShubert;user id=user;password=1234;MultipleActiveResultSets=True;App=EntityFramework&amp;quot;" 
 providerName="System.Data.EntityClient" /&gt;
&lt;/connectionStrings&gt;
--&gt;
</code></pre>

This is what I do now. I am commenting the connection string. I want to automate the whole thing.

Change connString dynamically

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

 我目前正在和Entity Framework合作一个ASP.NET MVC项目。该解决方案包括ASP.NET MVC应用程序和一个DataProvider项目。该项目只包括一个EF模型，因为我有一个与我共享数据库的合作伙伴。 问题在于，我们实际上并不共享同一个数据库。我的意思是，数据库的实际服务器并不相同。我们有相同...

问动态更改connString
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问动态更改connStringEN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问动态更改connString
EN