locked
Query Designer Not Working In Visual Studio 2017 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User1999497519 posted

    I just downloaded VS 2017. I have the server explorer window opened and connected to a  database.  The problem I'm having is the query designer toolbar is disabled.

    Thanks

    Monday, October 23, 2017 3:41 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User347430248 posted

    Hi steve mracek,

    it's looks like in Visual Studio 2017. this functionality is removed.

    I also find other threads in which they had faced the same issue like yours.

    Visual Query Designer

    to work around the issue , you can try to refer steps below may help you.

          1. In the Server explorer create a new connection

    VS - Query Designer 0

    1. You see the following window:

    VS - Query Designer 1

    1. Then Change the data source – it is really important that you choose Microsoft SQL Server and as Data provider – .NET Framework Data Provider for OLE DB (yes, you need OLE DB, because with the native SQL Server provider, the query designer just won’t work).

    VS - Query Designer 2

    After you define your connection to the database in that manner, all new queries, that you start, will be using the Query Designer framework (the well-known MS Access-like area :) ).

    Reference:

    How to enable Query Designer for SQL Server in Visual Studio

    Regards

    Deepak

    Tuesday, October 24, 2017 2:38 AM