Visual Query Designer not accessible in when connecting to SQL Server 2012 in Visual Studio 2012

Question

When I right click the Tables node in Server Explorer and choose "New Query", rather than seeing the visual designer, I now see a text designer with no obvious way to get to the visual designer (see screen shot).

Notice how the Query Designer tools are all greyed out. Is there any way to get back to the visual designer?

If it makes a difference, the database I'm connecting to is SQL Server 2012 Express.

EDIT

I have done some more research and it appears I should be able to see the designer by just creating a new query (http://msdn.microsoft.com/en-us/library/ms172011.aspx). I can't find any option that may affect this behaviour. It also means I can't just edit a row in my test DB, which is driving me crazy!!!

EDIT 2

OK, the behaviour I get is based on the database I connect to. When I add a connection to an SQL Server 2008 database, right click and choose "New Query" I get the visual designer. When I connection to an SQL Server 2012 database and do exactly the same thing I get the text SQL editor with no access to a visual designer!!!

Answer 1

While creating the database connection to SQL Server, select the .NET Data Provider as - .NET Framework Data Provider for OLEDB to get the Visual Query Designer in VS 2012 !