I can't believe I couldn't find a working solution to this after an hour of searching. I'm following this article on Entity Framework 6.0 which gives a simple walk-through on Code First. I created the project and installed the latest EF Nuget package for the project to compile. I also verified that I have Microsoft SQL Server 2012 Express LocalDB installed which came with Visual Studio 2013. I don't have any other instances of SQL installed on my local computer. The program runs and entries are added to the database and outputted in the console. But when the article says "check your localdb" it doesn't say how! I don't see any '.mdf' or '.ldf' files created under the project folder. I tried every way to connect Visual Studio's Server Explorer to LocalDB. The wizard cannot locate (localdb) or cannot find any provider in Server Explorer to accept connection string like (localdb)\v11.0;Integrated Security=true; I've seen this asked several places in StackOverflow but no answer works or marked as answer. Please help, this doesn't have to be this frustrating!

连接Visual Studio服务器资源管理器到LocalDB的步骤是什么?


当前回答

这对我很管用。

打开命令提示符 运行"SqlLocalDB.exe start" 输出说明"LocalDB instance "mssqllocaldb" started." 在VS中,查看/服务器资源管理器/(右键单击)数据连接/添加连接 数据来源:Microsoft SQL Server (SqlClient) 服务器名称:(localdb)\MSSQLLocalDB 登录服务器:使用Windows身份验证 按“测试连接”,然后确定。

其他回答

https://aspblogs.blob.core.windows.net/media/dixin/Open-Live-Writer/89ee21b2c263_49AE/image_thumb_5.png Windows应用程序日志错误 计算机\HKEY_CURRENT_USER\软件\Microsoft\Microsoft SQL Server\UserInstances{2DD3D445-34C1-4251-B67D-7DFEED432A87}

只需将ParentInstance更改为MSSQL14E。LOCALDB或mssql15 .LOCALDB。

https://weblogs.asp.net/dixin/installing-sql-server-2017-2019-localdb-and-resolve-the-engine-versioning-problem?__r=8d90635095e1cd4

使用SQL Server 2017和Visual Studio 2015,我使用本地主机\SQLEXPRESS

在Visual Studio 2017中最快的方法是转到Tools -> SQL Server -> New query..从Local databases中选择,并在底部选择所需的数据库名称。

替代方法

Visual Studio 2017服务器名称为:

(localdb)\MSSQLLocalDB

使用菜单工具添加新的连接->连接到数据库…

选择在:

数据来源:Microsoft SQL Server (SqlClient) 服务器名称:(localdb)\MSSQLLocalDB 登录服务器:使用Windows身份验证

按Refresh按钮获取数据库名称:)

Visual Studio 2015 RC,已经安装了LocalDb 12,类似于之前的说明,但仍然不应该被要求知道“魔术”,在使用之前,默认实例应该已经打开… 咆哮完毕,无解:

cmd> sqllocaldb start

会显示

LocalDB instance "MSSQLLocalDB" started.

您的实例名可能不同。无论哪种方式,弹出到VS,打开服务器资源管理器,右键单击数据连接,选择添加,选择SQL Server,在服务器名类型中:

(localdb)\MSSQLLocalDB

不输入数据库名称,单击“Test Connection”。