我应该如何编辑实体框架连接字符串？
我最近必须编辑 app.config 文件来更改实体框架数据模型（.edmx 文件）的连接字符串。但我想知道：有没有办法使用设计器编辑 EF 连接字符串？
原始连接字符串是由实体数据模型向导自动生成的。连接字符串将无法更改 - 它在 .edmx 设计器的属性窗口中保持禁用状态。如果可以的话，我喜欢避免手动编辑 XML（在 app.config 中），所以我想知道是否有办法返回到原始向导屏幕以进行连接字符串更改并让该工具编辑 app.config 文件为我。
I recently had to edit my app.config file to change the connection string for an Entity Framework data model (.edmx file). But I'd like to know: Is there a way to edit the EF connection string using the designer?
The original connection string is auto-generated by the Entity Data Model wizard. The connection string then cannot be changed - it remains disabled in the properties window of the .edmx designer. I like to avoid editing XML by hand if I can (in app.config), so I was wondering if there is a way to get back into the original wizard screen to make connection string changes and let the tool edit the app.config file for me.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
如果您从
app.config文件中删除连接字符串，重新运行实体数据模型向导将指导您构建新连接。If you remove the connection string from the
app.configfile, re-running the entity Data Model wizard will guide you to build a new connection.不可以，您无法在设计器中编辑连接字符串。连接字符串不是 EDMX 文件的一部分，它只是配置文件中的引用值，可能是因为它在属性窗口中只是只读的。
修改配置文件是一项常见任务，因为有时您希望在不重建应用程序的情况下进行更改。这就是配置文件存在的原因。
No, you can't edit the connection string in the designer. The connection string is not part of the EDMX file it is just referenced value from the configuration file and probably because of that it is just readonly in the properties window.
Modifying configuration file is common task because you sometimes wants to make change without rebuilding the application. That is the reason why configuration files exist.
您通常在 Web.config 中定义连接字符串。生成 edmx 后，连接字符串将存储在 App.Config 中。如果您想更改连接字符串，请转到 app.config 并删除所有连接字符串。现在转到 edmx，右键单击设计器界面，选择从数据库更新模型，从下拉列表中选择连接字符串，单击下一步、添加或刷新（选择什么）你想要）并完成。
在输出窗口中，它将显示类似这样的内容，
生成的模型文件：UpostDataModel.edmx。
从数据库加载元数据花费了 00:00:00.4258157。
生成模型花费了 00:00:01.5623765。
将连接字符串添加到 App.Config 文件中。
You normally define your connection strings in Web.config. After generating the edmx the connection string will get stored in the App.Config. If you want to change the connection string go to the app.config and remove all the connection strings. Now go to the edmx, right click on the designer surface, select Update model from database, choose the connection string from the dropdown, Click next, Add or Refresh (select what you want) and finish.
In the output window it will show something like this,
Generated model file: UpostDataModel.edmx.
Loading metadata from the database took 00:00:00.4258157.
Generating the model took 00:00:01.5623765.
Added the connection string to the App.Config file.
请按照以下步骤操作：
文件）
应为空），再次关闭 edmx 文件
Follow the next steps:
file)
should be blank), close the edmx file again
在任何文本编辑器中打开 .edmx 文件，更改 Schema="您所需的架构"，并打开 app.config/web.config，从连接字符串。你完成了。
Open .edmx file any text editor change the Schema="your required schema" and also open the app.config/web.config, change the user id and password from the connection string. you are done.