Options

SQLPrompt Doesnot work in Visual Studio 2022

jmontero19jmontero19 Posts: 3 Bronze 1
edited November 28, 2023 5:27PM in SQL Prompt
Hello Redgate Folks,

Starting on version 10.14.2.447 the SQLPrompt Suggestion stopped working to suggest schema objects, and the error looks like it is related to updates on the SSDT to include the set_Encrypt option in the latest version of the SSDT for Visual Studio 2022.

I tried to revert the version to the prior one, but the issue is the same in the SQLPrompt 10.14.1.4347.

Below is part of the SQLPrompt Log.
Thank you for being so helpful.

023-11-27 16:01:46.983 -06:00 [Verbose] Usage reporting request made to https://productusage.red-gate.com/v1/usageevents
  Number of submitted usage events = 2
  HTTP status code = 200 OK
  Response body =
2023-11-27 16:02:04.896 -06:00 [Information] Created new ServerCandidate for server: PROD
2023-11-27 16:02:05.188 -06:00 [Warning] Failed to do background loading of database candidate PROD.
2023-11-27 16:02:05.286 -06:00 [Debug] AutoRefreshing database master
2023-11-27 16:02:20.511 -06:00 [Error] Report error dialog UI shown
System.MissingMethodException: Method not found: 'Void Microsoft.Data.SqlClient.SqlConnectionStringBuilder.set_Encrypt(Boolean)'.
   at RedGate.SqlPrompt.Shell.Api.ConnectionProperties.ToMsDataConnectionString(Int32 connectionTimeout)
   at RedGate.SqlPrompt.Shell.Api.ConnectionFactory.CreateMsDataConnection(ConnectionProperties connectionProperties)
   at RedGate.SqlPrompt.Cache.Candidates.ServerCandidate.LoadServer()
2023-11-27 16:02:57.444 -06:00 [Debug] AutoRefreshing database master


Tagged:
· Share on Twitter

Best Answer

  • Options
    chrisqtranchrisqtran Posts: 93 Silver 1
    Answer ✓
    Hi all, 

    For the error below, there should be an update later this week that should resolve the issue:


    I will keep y'all updated as soon as it is released.

    · Share on Twitter

Answers

Sign In or Register to comment.