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


当前回答

以admin用户运行CMD。

from start menu 'cmd' - wait for it to find it. Right click on cmd, and select open as administrator type : cd C:\Program Files\Microsoft SQL Server\120\Tools\Binn type : SqlLocalDB start now type : SqlLocalDB info Shows the running sql instances available... choose what you want... to find more about the instance type : SqlLocalDB info instanceName now from VS you can setup your connection In VS, View/Server Explorer/(Right click) Data Connections/Add Connection Data Source: Microsoft SQL Server (SqlClient) Server name: (localdb)\MSSQLLocalDB Log on to the server: Use Windows Authentication Press "Test Connection", Then OK. job done

其他回答

这对我很管用。

打开命令提示符 运行"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对象资源管理器(SSOX)

与其他答案不同,这种方法使用: —无特殊命令。 —无复杂配置。 只需使用SQL Server对象资源管理器

这很简单……

从“视图”菜单中,打开SQL Server对象资源管理器。

右击{YourTableName}表>视图设计器

完成了。

在Visual Studio 2012中,我所要做的就是输入:

(localdb)\v11.0

Visual Studio 2015和Visual Studio 2017更改为:

(localdb)\MSSQLLocalDB

添加Microsoft SQL server数据源时,将其作为服务器名:

View/Server Explorer/(Right click) Data Connections/Add Connection

然后填充数据库名称。我不需要在接受的答案中执行所有其他步骤,尽管如果服务器名称在服务器名称组合框中自动可用就更好了。

您还可以使用以下命令浏览机器上可用的LocalDB数据库名称:

View/SQL Server Object Explorer.

选择在:

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

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