从配置实体框架的连接字符串不 [英] Entity Framework connection string not from config

问题描述

 公共类语境的DbContext 
 {
公共上下文（字符串CONNSTRING）：基地（CONNSTRING）
 {
 Database.SetInitializer（新MyContextInitializer（））; 
} 
 // ... 
  

需要传递一个连接字符串上下文构造函数。该字符串应该怎么样子，例如，SQL精简？试过，但没有成功：

 上下文DB =新的上下文（提供者= System.Data.SqlServerCe.4.0;数据源D：\\Context.sdf）; 
  

编辑：

如果我试试这个字符串：数据源= D：\\Context.sdf

<块引用>

System.Data.ProviderIncompatibleException了未处理

消息=错误而从数据库中获取信息提供者发生了。结果
这可以通过实体框架使用了不正确的连接字符串引起的。
检查内部异常的详细信息，并确保连接字符串是正确的。

来源=的EntityFramework

如果我尝试提这样的提供商：数据源= D：\\Context.sdf;提供商= System.Data.SqlServerCe.4.0

System.ArgumentException了未处理

消息=不支持关键字：供应商

来源= System.Data这

解决方案

我与MVC 4码类似的错误第一个（在运行更新的数据库）。我得到的错误：

同时获得由
数据库提供信息时出错。这可以通过实体框架使用了不正确
连接字符串引起的。检查内部异常的详细信息，并确保
连接字符串是正确的。

原来我是缺少一些关键在我的web.config信息得到它所有的LocalDB工作。这里的重要路段（我用的参考材料来自的 http://blogs.msdn.com/b/adonet/archive/2012/01/12/ef-4-3-configuration-file-settings.aspx ）：

 <结构> 
< configSections> 
<节名称=的EntityFrameworkTYPE =System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection，的EntityFramework，版本4.3.1.0 =文化=中性公钥= b77a5c561934e089/> 
< / configSections> 
<&是connectionStrings GT; 
<添加名称=DefaultConnection的connectionString =数据源=（的LocalDB）\v11.0;初始目录= ESTdb-01;集成安全性=真的providerName =System.Data.SqlClient的/> ; 
< /&是connectionStrings GT; 
 
<&的EntityFramework GT; 
< defaultConnectionFactory TYPE =System.Data.Entity.Infrastructure.SqlConnectionFactory，的EntityFramework> 
<&参数GT; 
<参数值=数据源=（的LocalDB）\v11.0;集成安全性= TRUE; MultipleActiveResultSets = TRUE/> 
< /参数> 
< / defaultConnectionFactory> 
< /&的EntityFramework GT; 
< /结构> 
  

和良好的措施，这是我整个的web.config（我使用MVC 4，EF 4.3 .1，EF-迁移）：？？

 < XML版本=1.0编码=UTF-8> ; 
<结构> 
< configSections> 
<节名称=的EntityFrameworkTYPE =System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection，的EntityFramework，版本4.3.1.0 =文化=中性公钥= b77a5c561934e089/> 
< / configSections> 
<&是connectionStrings GT; 
<添加名称=DefaultConnection的connectionString =数据源=（的LocalDB）\v11.0;初始目录= ESTdb-01;集成安全性=真的providerName =System.Data.SqlClient的/> ; 
< /&是connectionStrings GT; 
<&的appSettings GT; 
<添加键=网页：版本值=2.0.0.0/> 
<添加键=网页：启用VALUE =真/> 
<添加键=PreserveLoginUrlVALUE =真/> 
<添加键=ClientValidationEnabledVALUE =真/> 
<添加键=UnobtrusiveJavaScriptEnabledVALUE =真/> 
< /的appSettings> 
<&的System.Web GT; 
<编译调试=真targetFramework =4.0/> 
<身份验证模式=表格> 
<形式loginUrl =〜/帐号/登录超时=2880/> 
< /认证> 
<网页和GT; 
<&命名空间GT; 
<添加命名空间=System.Web.Helpers/> 
<添加命名空间=System.Web.Mvc/> 
<添加命名空间=System.Web.Mvc.Ajax/> 
<添加命名空间=System.Web.Mvc.Html/> 
<添加命名空间=System.Web.Routing/> 
<添加命名空间=System.Web.WebPages/> 
< /命名空间> 
< /页> 
<型材defaultProvider =DefaultProfileProvider> 
<供应商> 
<添加名称=DefaultProfileProviderTYPE =System.Web.Providers.DefaultProfileProvider，System.Web.Providers，版本= 1.0.0.0，文化=中性公钥= 31bf3856ad364e35的connectionStringName =DefaultConnection的applicationName = //> 
< /供应商> 
< / profile文件> 
<会员defaultProvider =DefaultMembershipProvider> 
<供应商> 
<添加名称=DefaultMembershipProviderTYPE =System.Web.Providers.DefaultMembershipProvider，System.Web.Providers，版本= 1.0.0.0，文化=中性公钥= 31bf3856ad364e35的connectionStringName =DefaultConnectionenablePasswordRetrieval = 假enablePasswordReset设置=真requiresQuestionAndAnswer =假requiresUniqueEmail =假maxInvalidPasswordAttempts =5minRequiredPasswordLength =6minRequiredNonalphanumericCharacters =0passwordAttemptWindow =10的applicationName =//> 
< /供应商> 
< /会员> 
< roleManager defaultProvider =DefaultRoleProvider> 
<供应商> 
<添加名称=DefaultRoleProviderTYPE =System.Web.Providers.DefaultRoleProvider，System.Web.Providers，版本= 1.0.0.0，文化=中性公钥= 31bf3856ad364e35的connectionStringName =DefaultConnection的applicationName = //> 
< /供应商> 
< / roleManager> 
<的sessionState模式=是InProccustomProvider =DefaultSessionProvider> 
<供应商> 
<添加名称=DefaultSessionProviderTYPE =System.Web.Providers.DefaultSessionStateProvider，System.Web.Providers，版本= 1.0.0.0，文化=中性公钥= 31bf3856ad364e35的connectionStringName =DefaultConnection的applicationName = //> 
< /供应商> 
< /&的sessionState GT; 
< /system.web> 
< system.webServer> 
<验证validateIntegratedModeConfiguration =FALSE/> 
<模块runAllManagedModulesForAllRequests =真/> 
< /system.webServer> 
<&运行GT; 
< assemblyBinding的xmlns =瓮：架构 - 微软COM：asm.v1> 
< dependentAssembly> 
< assemblyIdentity名称=System.Web.Helpers公钥=31bf3856ad364e35/> 
< bindingRedirect oldVersion =1.0.0.0-2.0.0.0NEWVERSION =2.0.0.0/> 
< / dependentAssembly> 
< dependentAssembly> 
< assemblyIdentity名称=System.Web.Mvc公钥=31bf3856ad364e35/> 
< bindingRedirect oldVersion =0.0.0.0-4.0.0.0NEWVERSION =4.0.0.0/> 
< / dependentAssembly> 
< dependentAssembly> 
< assemblyIdentity名称=System.Web.WebPages公钥=31bf3856ad364e35/> 
< bindingRedirect oldVersion =1.0.0.0-2.0.0.0NEWVERSION =2.0.0.0/> 
< / dependentAssembly> 
< / assemblyBinding> 
< /运行> 
<&的EntityFramework GT; 
< defaultConnectionFactory TYPE =System.Data.Entity.Infrastructure.SqlConnectionFactory，的EntityFramework> 
<&参数GT; 
<参数值=数据源=（的LocalDB）\v11.0;集成安全性= TRUE; MultipleActiveResultSets = TRUE/> 
< /参数> 
< / defaultConnectionFactory> 
< /&的EntityFramework GT; 
< /结构> 
  

public class Context : DbContext
{
    public Context(string connString) : base(connString) 
    {
        Database.SetInitializer(new MyContextInitializer());
    }
//...

Need to pass a connection string to the context constructor. How should the string look like, for example, for SQL Compact? Tried this, but no success:

Context db = new Context("Provider=System.Data.SqlServerCe.4.0;Data Source=D:\\Context.sdf");

Edit:

If I try this string: "Data Source=D:\\Context.sdf"

System.Data.ProviderIncompatibleException was unhandled

Message=An error occurred while getting provider information from the database.
This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Source=EntityFramework

And if I try to mention the provider like this: "Data Source=D:\\Context.sdf;provider=System.Data.SqlServerCe.4.0"

System.ArgumentException was unhandled

Message=Keyword not supported: 'provider'.

Source=System.Data

解决方案

I had a similar error with MVC 4 code first (while running update-database). The error I was getting:

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Turns out that I was missing some crucial information in my web.config to get it all working with localDB. Here's the important sections (I used reference material from http://blogs.msdn.com/b/adonet/archive/2012/01/12/ef-4-3-configuration-file-settings.aspx):

<configuration>
  <configSections>
   <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=ESTdb-01;Integrated Security=true" providerName="System.Data.SqlClient" />
  </connectionStrings>

  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="Data Source=(localdb)\v11.0; Integrated Security=True; MultipleActiveResultSets=True" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>
</configuration>

And for good measure, here's my whole web.config (I'm using MVC 4, EF 4.3.1, EF-Migrations):

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.3.1.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
  </configSections>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=ESTdb-01;Integrated Security=true" providerName="System.Data.SqlClient" />
  </connectionStrings>
  <appSettings>
    <add key="webpages:Version" value="2.0.0.0" />
    <add key="webpages:Enabled" value="true" />
    <add key="PreserveLoginUrl" value="true" />
    <add key="ClientValidationEnabled" value="true" />
    <add key="UnobtrusiveJavaScriptEnabled" value="true" />
  </appSettings>
  <system.web>
    <compilation debug="true" targetFramework="4.0" />
    <authentication mode="Forms">
      <forms loginUrl="~/Account/Login" timeout="2880" />
    </authentication>
    <pages>
      <namespaces>
        <add namespace="System.Web.Helpers" />
        <add namespace="System.Web.Mvc" />
        <add namespace="System.Web.Mvc.Ajax" />
        <add namespace="System.Web.Mvc.Html" />
        <add namespace="System.Web.Routing" />
        <add namespace="System.Web.WebPages" />
      </namespaces>
    </pages>
    <profile defaultProvider="DefaultProfileProvider">
      <providers>
        <add name="DefaultProfileProvider" type="System.Web.Providers.DefaultProfileProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" applicationName="/" />
      </providers>
    </profile>
    <membership defaultProvider="DefaultMembershipProvider">
      <providers>
        <add name="DefaultMembershipProvider" type="System.Web.Providers.DefaultMembershipProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" applicationName="/" />
      </providers>
    </membership>
    <roleManager defaultProvider="DefaultRoleProvider">
      <providers>
        <add name="DefaultRoleProvider" type="System.Web.Providers.DefaultRoleProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" applicationName="/" />
      </providers>
    </roleManager>
    <sessionState mode="InProc" customProvider="DefaultSessionProvider">
      <providers>
        <add name="DefaultSessionProvider" type="System.Web.Providers.DefaultSessionStateProvider, System.Web.Providers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="DefaultConnection" applicationName="/" />
      </providers>
    </sessionState>
  </system.web>
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <modules runAllManagedModulesForAllRequests="true" />
  </system.webServer>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="1.0.0.0-2.0.0.0" newVersion="2.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.0.0" newVersion="4.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" />
        <bindingRedirect oldVersion="1.0.0.0-2.0.0.0" newVersion="2.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="Data Source=(localdb)\v11.0; Integrated Security=True; MultipleActiveResultSets=True" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>
</configuration>

这篇关于从配置实体框架的连接字符串不的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！