出错动态改变连接字符串 [英] Error while Changing the connection string dynamically

问题描述

林改变了我的实体连接字符串的时候有这个问题。

Im having this problem when changing my entities connection string.

这里是code：

SqlConnectionStringBuilder sqlBuilder = new SqlConnectionStringBuilder();
                        sqlBuilder.DataSource = @"KURT-PC\SQLEXPRESS";
                        sqlBuilder.InitialCatalog = "KurtDB";
                        sqlBuilder.UserID = "Admin";
                        sqlBuilder.Password = "123456";
                        sqlBuilder.IntegratedSecurity = false;
                        sqlBuilder.MultipleActiveResultSets = true;

                        EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
                        entityBuilder.Provider = "System.Data.SqlClient";
                        entityBuilder.ProviderConnectionString = sqlBuilder.ToString();
                        entityBuilder.Metadata = @"res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl";

                        this.Entities.Connection.ConnectionString = conn.Connection.ConnectionString = entityBuilder.ConnectionString.ToString();

当它试图更改连接字符串它给我一个InvalidOperationEsception。

when it tries to change the connection string its giving me an InvalidOperationEsception.

错误的详细信息：
元数据已经注册通过打开连接或构建一个MetadataWorkspace连接后允许没有修改连接。

error details: No modifications to connection are permitted after the metadata has been registered either by opening a connection or constructing the connection with a MetadataWorkspace.

任何帮助它离开我speachless ....

Any help its leaving me speachless....

推荐答案

我假设你的榜样， this.Entities 是一个实体框架对象的实例语境。

I'm assuming that in your example, this.Entities is an instance of an Entity Framework Object Context.

该错误消息意味着你不能简单地分配新的连接字符串连接的实体的财产对象

The error message means that you cannot simply assign the new connection string to the Connection property of the Entities object.

相反，尝试将它作为一个构造函数的参数：

Instead, try passing it as a constructor parameter:

• 找到你实例实体行：结果
  this.Entities =新...（）;


• 将其更改为这样的事情：结果
  this.Entities =新...（entityBuilder.ConnectionString.ToString（））;

• locate the line where you instantiate Entities:
  this.Entities = new ...();
• change it to something like this:
  this.Entities = new ...(entityBuilder.ConnectionString.ToString());

这篇关于出错动态改变连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！