不支持“数据源”关键字。 （ASP.Net应用程序，Entity框架5，代码第一，迁移） [英] The 'data source' keyword is not supported. (ASP.Net app, Entity-framework 5, Code first, migrations)

问题描述

我有一个OData / WCF数据服务端点（ASP.Net站点），我想从使用EF代码第一个数据模型与SQL Server 2012作为后端切换到EF代码第一个数据模型与LocalDB作为后端 - 在我们的开发机使用Visual Studio 2012.代码放置在TFS中，我们在5-6个开发人员之间共享代码。

I have an OData/WCF Data Services endpoint (ASP.Net site) that I would like to switch from using EF Code first datamodel with SQL Server 2012 as backend to EF Code first datamodel with LocalDB as backend - on our dev machines using Visual Studio 2012. Code is placed in TFS and we share the code between 5-6 developers.

现有的单元测试在切换到LocalDB后运行顺利。单元测试项目的配置如下：

Existing unit tests run smoothly after switching to LocalDB. The config for the unit test project is this:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
    </configSections>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
      </entityFramework>
</configuration>

OData端点的配置文件为

The configuration file for the OData endpoint is this

<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <connectionStrings>
    <add name="MyStorageContext" connectionString="Data Source=(LocalDb)\v11.0;Integrated Security=True" providerName="System.Data.EntityClient" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>
</configuration>

< - 不支持关键字。尝试使用配置运行网站时出现相同的消息。

The problem is that whenever I press "save" in Visual Studio, it complains about "the data source"-keyword is not supported. The same message appears when trying to run the site using the configuration.

我做错了什么？根据其他帖子在这里的连接字符串看起来点。

What am I doing wrong? According to other posts here the connection string looks spot on.

编辑：从连接字符串中删除双反斜杠 - 相同的结果，虽然

Removed double backslash from connection string - same results, though

推荐答案

尝试此连接字符串：

<connectionStrings>
        <add
          name="MyStorageContext"
          providerName="System.Data.SqlClient"
          connectionString="Server=(LocalDb)\v11.0;Database=DataBaseName;Trusted_Connection=true;MultipleActiveResultSets=true;"/>
</connectionStrings>

这篇关于不支持“数据源”关键字。 （ASP.Net应用程序，Entity框架5，代码第一，迁移）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！