[SqlException (0x80131904): Cannot attach the file ‘xxx.mdf‘ as database ‘aspnet-MvcMovie‘.]

最近在搞Entityframework框架时遇到一个奇葩的问题,使用微软提供案列无法自动生成项目,俺遇到的情况是两个不同项目使用了相同的连接字符串,导致数据库物理路径不同,但数据库名称一样,所以不报错才怪,然后就出现了文章所提到的问题

解决方法:删除数据库中对应的数据库,重新运行项目

If you get an error that indicates a table already exists and can’t be created, it is probably because you ran the application after you deleted the database and before you executed update-database. In that case, delete the Movies.mdf file again and retry the update-database command. If you still get an error, delete the migrations folder and contents then start with the instructions at the top of this page (that is delete the Movies.mdf file then proceed to Enable-Migrations). If you still get an error, open SQL Server Object Explorer and remove the database from the list. If you get an error indicating “Cannot attach the file .mdf as database”, remove the Initial Catalog property as part of the connection string in the web.config file.

entity framework codefirst 用户代码未处理DataException，InnerException基础提供程序在open上失败，数据库生成失败