Visual Studio 2013 SQL 查询和视图设计器未出现 [英] Visual Studio 2013 SQL Query and View Designer not appearing

问题描述

不知道为什么查询和视图设计器没有按规定显示

Not sure why the Query and View Designer is not appearing as per

http://msdn.microsoft.com/en-us/library/vstudio/ms172013.aspx

这是一个 ASP.net 项目，在 AppData 文件夹中有数据库，并使用 SQL 2008 Express 进行连接.

It's an ASP.net project with database in the AppData folder, and a connection using SQL 2008 Express.

如果有帮助，连接字符串是:

If it helps the connection string is:

Data Source=.SQLEXPRESS;AttachDbFilename="C:folders...App_Datadatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True

Data Source=.SQLEXPRESS;AttachDbFilename="C:folders...App_Datadatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True

如果我在 VS2012 中打开项目(我已经在这个项目上工作了一段时间)，找到一个表，右键单击，新查询，我得到了很好的交互式视觉设计工具.

If I open the project in VS2012 (where I've worked on this project for some time), find a table, right click, new query, I get the nice interactive visual design tool.

如果我在 VS2013(刚刚安装)中打开项目并执行相同的操作，名为 SQLQuery1.sql 的空白页面以及与 SQL Express 的基本连接(即 master、model 等)

If I open the project in VS2013 (just installed) and do the same, blank page named SQLQuery1.sql and a basic connection to SQL Express (ie. master, model, etc.)

MS 页面告诉我工具/选项/可视化数据库工具 - 但我的安装中不存在！

MS page tells me Tools / Options / Visual Database tools - but this doesn't exist on my installation!

我错过了什么吗?

还尝试使用空白项目，添加 App_Data 和一个新数据库(因此使用 LocalDB)，添加一个表，右键单击，新查询 - 完全相同的空白文件.

Also tried with blank project, added App_Data and a new database (so using LocalDB), added a table, right click, new query - exactly the same blank file.

推荐答案

我遇到了同样的问题，我想我已经找到了解决方案.

I have been having the same problem and think I have found the solution.

当您将连接添加到数据库时，在添加连接对话框中.点击数据源旁边的更改..."

When you are adding the connection to the Database, in the Add Connection Dialog. Click 'Change...' next to the Data source

对话框打开，显示更改数据源"

Dialog opens showing 'Change Data Source'

您可能选择了Microsoft SQL Server"，然后在下面有一个下拉菜单，您可以选择:

You probable have selected 'Microsoft SQL Server' and then below that there is a drop down where you can select:

用于 OLE DB 的 .NET Framework 数据提供程序
.NET Framework Data Provider for SQL Server(这可能是默认选择的)

.NET Framework Data Provider for OLE DB
.NET Framework Data Provider for SQL Server (This is probably selected by default)

尝试更改为 OLE DB 连接.

try changing to the OLE DB connection.

单击确定"，然后在添加连接"对话框中完成其余的连接.然后我发现使用数据库的工作方式与在 VS2012 中以及您在上面描述的一样.

Click OK, and then complete the rest of the connection on the 'Add Connection' dialog. I have then found that using the database works as it did in VS2012 and as you are describing above.

这篇关于Visual Studio 2013 SQL 查询和视图设计器未出现的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！