ASP.NET System.Data.EntityClient连接字符串帮助 [英] ASP.NET System.Data.EntityClient connection string help

问题描述

我是一个共享的服务器上运行ASP.NET MVC和我在连接通过System.Data.EntityClient到SQL的问题。下面是我的软管供应商给了我连接到SQL连接字符串和一个VS开发过程中配置我的本地机器，什么都要我的连接字符串样子，当我部署到服务器？

从我的托管服务提供商：

 ＆LT;添加名称=WeddingsDBEntities
  的connectionString =数据源=＆LT;服务器名称取代;初始目录=＆LT;数据库名称取代;用户ID =＆lt;使用者ID取代;密码=＆LT;密码取代;
  的providerName =System.Data.EntityClient/＆GT;
 

从VS（开发中）：

<$p$p><$c$c>connectionString=\"metadata=res://*/Models.WeddingsModel.csdl|res://*/Models.WeddingsModel.ssdl|res://*/Models.WeddingsModel.msl;provider=System.Data.SqlClient;provider连接字符串=数据源= \\ SQLEX $ P $干燥综合征; AttachDbFilename = | DataDirectory目录| \\ WeddingsDB.mdf;集成安全=真;用户实例=真; MultipleActiveResultSets =真的providerName =System.Data.EntityClient

谢谢！

解决方案

您必须包装连接字符串instide这是在格式

一个实体的连接字符串

 ＆LT;添加名称=名称
  的connectionString =元=＆LT;概念模型＆GT; |＆LT;存储模型＆GT; |＆LT;映射模型取代;
  供应商= LT;底层连接提供商取代;
  提供连接字符串=安培; QUOT;＆LT;底层的ConnectionString＆GT;＆安培; QUOT;
  的providerName =System.Data.EntityClient/＆GT;
 

而不是：

 ＆LT;添加名称=WeddingsDBEntities
  的connectionString =数据源=＆LT;服务器名称取代;初始目录=＆LT;数据库名称取代;用户ID =＆lt;使用者ID取代;密码=＆LT;密码取代;
  的providerName =System.Data.EntityClient/＆GT;
 

使用这样的：

 ＆LT;添加名称=WeddingsDBEntities
  connectionString=\"metadata=res://*/Models.WeddingsModel.csdl|res://*/Models.WeddingsModel.ssdl|res://*/Models.WeddingsModel.msl;provider=System.Data.SqlClient;provider连接字符串=安培; QUOT;数据源=＆LT;服务器名称＆gt ;;初始目录=＆LT;数据库名称＆gt ;;用户ID =＆lt;使用者ID取代;密码=＆LT;密码取代; MultipleActiveResultSets =真放; QUOT;
  的providerName =System.Data.EntityClient/＆GT;
 

I'm running ASP.NET MVC on a shared server and I'm having problems connecting to SQL via System.Data.EntityClient. Below is the connection string that my hosing provider gave me to connect to SQL and the one that VS configured for my local machine during development, what should my connection string look like when I deploy to the server?

From my hosting provider:

<add name="WeddingsDBEntities" 
  connectionString="data Source=<server name>; Initial Catalog=<db name>; User ID=<user ID>; Password=<password>;" 
  providerName="System.Data.EntityClient"/>

From VS (during development):

connectionString="metadata=res://*/Models.WeddingsModel.csdl|res://*/Models.WeddingsModel.ssdl|res://*/Models.WeddingsModel.msl;provider=System.Data.SqlClient;provider connection string="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WeddingsDB.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"

Thanks!

解决方案

You have to wrap the connection string instide an entity connection string which is in the format of

<add name="Name"
  connectionString="metadata=<Conceptual Model>|<Store Model>|<Mapping Model>;
  provider=<Underlying Connection Provider>;
  provider connection string=&quot;<Underlying ConnectionString>&quot;" 
  providerName="System.Data.EntityClient"/>

Instead of:

<add name="WeddingsDBEntities" 
  connectionString="data Source=<server name>; Initial Catalog=<db name>; User ID=<user ID>; Password=<password>;" 
  providerName="System.Data.EntityClient"/>

Use this:

<add name="WeddingsDBEntities"
  connectionString="metadata=res://*/Models.WeddingsModel.csdl|res://*/Models.WeddingsModel.ssdl|res://*/Models.WeddingsModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data Source=<server name>; Initial Catalog=<db name>; User ID=<user ID>; Password=<password>;MultipleActiveResultSets=True&quot;" 
  providerName="System.Data.EntityClient"/>

这篇关于ASP.NET System.Data.EntityClient连接字符串帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！