如何在Visual Studio服务器资源管理器中连接到LocalDB ?

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的步骤是什么?

当前回答

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

2021-04-23 08:55:13

其他回答

场景:Windows 8.1, VS2013 Ultimate, SQL Express已安装并运行，SQL Server浏览器已禁用。这招对我很管用:

First I enabled SQL Server Browser under services. In Visual Studio: Open the Package Manager Console then type: Enable-Migrations; Then Type Enable-Migrations -ContextTypeName YourContextDbName that created the Migrations folder in VS. Inside the Migrations folder you will find the "Configuration.cs" file, turn on automatic migrations by: AutomaticMigrationsEnabled = true; Run your application again, the environment creates a DefaultConnection and you will see the new tables from your context. This new connection points to the localdb. The created connection string shows: Data Source=(LocalDb)\v11.0 ... (more parameters and path to the created mdf file)

您现在可以创建一个新的连接服务器名称:(LocalDb)\v11.0(点击刷新) 连接到数据库:在下拉菜单中选择新数据库。

我希望这能有所帮助。

2015-05-15 18:27:37

好的，回答我自己的问题。

连接LocalDB到Visual Studio Server Explorer的步骤

打开命令提示符运行SqlLocalDB.exe start v11.0 执行SqlLocalDB.exe info v11.0命令复制以np:\…开头的实例管道名在Visual Studio中选择工具>连接到数据库… 对于服务器名输入(localdb)\v11.0。如果它不起作用，请使用前面复制的Instance管道名。您还可以使用它来连接SQL Management Studio。在下一个下拉列表中选择数据库单击OK

2014-02-04 23:24:56

修理不起作用。

与示例插图中一样，所有这些步骤都只提供对“系统”数据库的访问，而没有选择要访问的现有用户数据库的选项。

访问本地(非Express Edition) Microsoft SQL server实例的解决方案驻留在SQL server端:

打开运行对话框(WinKey + R) 类型:“services.msc” 选择SQL Server浏览器单击“属性” 将“禁用”改为“手动”或“自动” 当“Start”服务按钮启用时，单击它。

完成了!现在，您可以从连接属性中的“服务器名称”列表中选择本地SQL Server。

2014-09-25 13:15:53

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

cmd> sqllocaldb start

会显示

LocalDB instance "MSSQLLocalDB" started.

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

(localdb)\MSSQLLocalDB

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

2015-07-10 07:19:55

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

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

2021-04-23 08:55:13

如何在Visual Studio服务器资源管理器中连接到LocalDB ?

推荐文章

最新文章

标签