Sql Server LocalDB问题在Asp.NET MVC 4项目中 [英] Sql Server LocalDB Issue In Asp.NET MVC 4 Project

问题描述

当我尝试打开db_name.mdf文件时，我收到以下错误：

 数据库'{path } \db_name.MDF'无法打开，因为它是版本706.此服务器支持版本662及更早版本。不支持降级路径。无法打开新数据库'db_name.MDF'。 CREATE DATABASE中止了。尝试附加文件{$ path} \db_name.mdf的自动命名数据库失败。存在具有相同名称的数据库，或指定的文件无法打开，或位于UNC共享上。 
  

连接字符串如下：

 < add name =PasswordDBContextconnectionString =Data Source =（LocalDB）\v11.0; AttachDbFilename = | DataDirectory | \db_name.mdf; Integrated Security = TrueproviderName = System.Data.SqlClient/> 
  

我正在Visual Studio中工作的一个asp.net mvc 4项目。

非常感谢任何解决问题的帮助。谢谢。

解决方案

LocalDB是一个 SQL 2012 Express中引入的新功能 - 您将需要安装SQL 2012 Express LocalDb ，如果您需要在此使用MDF

Krzysztof Kozielczyk 已经发表了几个条目在LocalDB上这里 - 特别注意在完整IIS下运行时的问题。 / p>

使用ASP.NET的LocalDb的IMO仅适用于开发者机器配置 - 即当您准备好将（代码优先）的MVC 4应用程序部署到测试或生产环境，你应该考虑附件g ASPNETDB.MDF 更永久地添加到SQL实例。

I am getting the following error whenever I am trying to open the db_name.mdf file:

The database '{path}\db_name.MDF' cannot be opened because it is version 706. This server supports version 662 and earlier. A downgrade path is not supported. Could not open new database 'db_name.MDF'. CREATE DATABASE is aborted. An attempt to attach an auto-named database for file {$path}\db_name.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Connection string as follows:

<add name="PasswordDBContext" connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\db_name.mdf;Integrated Security=True" providerName="System.Data.SqlClient" />

I am working on a asp.net mvc 4 project within visual studio.

Any help to get the issue resolved are very much appreciated. Thanks.

解决方案

LocalDB is a new feature introduced in SQL 2012 Express - you will need to install SQL 2012 Express LocalDb if you need to use an MDF in this manner.

Krzysztof Kozielczyk has blogged several entries around on LocalDB here - take note especially of the issues when running under 'Full IIS'.

IMO using LocalDb with ASP.NET is for a developer machine config only - i.e. when you are ready to deploy your (code first?) MVC 4 app to a testing or production environment, you should consider attaching ASPNETDB.MDF more permanently to a SQL Instance.

这篇关于Sql Server LocalDB问题在Asp.NET MVC 4项目中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！