Visual Studio 2013 disabled Query Designer

Question

It looks like Query Designer is disabled in VS 2013, is this permanent "feature" or something that will be fixed in near futere?

steps to recreate:

using Microsoft Visual Studio Ultimate 2013 ( Version 12.0.21005.1 REL ; Microsoft .NET Framework Version 4.5.50938 )

using Server Explorer, open SQL 2008 database, right click on table / show table date, data available in the table is displayed but query design tools are disabled.

It works when using VS 2012 or VS 2010. VS 2012 didn't work with SQL 2012 as far as query designer is concerned but worked with SQL 2008.

Does it mean that VS 2013 did big step "forward" (yeah right) and took care of Query designer regardless of what SQL database it is connecting with? I hope it will be fixed, I realize that I could use SQL Server Management studio or VS 2010 when working with database but this functionality was already available, why it is disabled now?

I got it

It works, if in data source you specify Microsoft SQL Server + .NET Framework Data Provider for OLE DB

Answer 1

Hi,

As far as I know, it seems that some Data tools with Visual Studio 2012 has been moved to SQL Server Data Tools by Microsoft. Please see: http://stackoverflow.com/questions/13087965/visual-query-designer-not-accessible-in-when-connecting-to-sql-server-2012-in-vi I doubt that Query Designer also has been removed from VS 2013. But it seems that there is no SQL Server Data Tools for Visual Studio 2013 now.

To get the issue confirmed and diagnose by product team, would you please create connect report for it? You will get email notification for update.http://connect.microsoft.com/VisualStudio/feedback/CreateFeedback.aspx, if you submit it, you could share us the link here, so we could know the latest information from the Product team expert. And I will help you to vote it.

Best regards,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Having the same issue.

All working nicely on VS2012 connecting to SQL2008 database.

Visual table designer appears in VS2013, but anything else, blank page, manually set up the connection etc.

Tried all sorts of combinations on fresh install.

I realise that the tools moved, but all the installs are for VS2012, and everything says that it's all built in to VS2013.

Will be back to VS2012 until this is sorted.

Answer 3

Visual Studio Professional 2013; SQL 2008 R2 on the local network; Win 7 Pro workstation.

Design tools were not available using the ".NET Framework Provider for SQL Server"

Reconnected using the ".NET Framework Data Provider for OLE DB". Design tools are available.

Thanks jarekb

Shame on you Microsoft. Why you alla-time make it so hard?

Answer 4

Where are you specifying this setting?  I can't find it anywhere!

Answer 5

Right-click on the database entry and Modify the connection string, change the data source and switch from '.NET Framework Data Provider for SQL Server' to '.NET Framework Data Provider for OLE DB' in the lower box.

THEN, (completely illogical to me...) right click on the tables section of the database lists NOT the 'Stored Procedures'... You then get the Query Builder...

As previously commented... this 'update' in 2013 from all previous versions of VS is a backward step. (I suspect a case of over-engineering...) Let's hope that 2015 puts it right...

Follow-on:

I've now put up my previous 2010 instance of Visual Studio as I find that simple processes (CRUD on SPs) are easy in that version... can't seem to do it in VS2013.