Problem after update to Visual Studio 17.8

JeromeLJeromeL Posts: 10 Bronze 4
in SQL Change Automation
Hi.

We've just updated Visual Studio to the latest version, 17.8. Since then, the plugin crashes on build/cleanup or even opening the SCA tool window.

The error ->
MSBUILD: Error:  : Method not found: 'Boolean Microsoft.Data.SqlClient.SqlConnectionStringBuilder.get_Encrypt()'.: Method not found: 'Boolean Microsoft.Data.SqlClient.SqlConnectionStringBuilder.get_Encrypt()'.

VS Version : 17.8
SCA extension version : 4.6.23312.2442

Thanks

Tagged:
· Share on Twitter
«1

Answers

  • daviepdaviep Posts: 7 New member
    Same issue here

    Microsoft Visual Studio Professional 2022 Version 17.8.0
    Redgate SQL Change Automation   4.6.23319.2501
    · Share on Twitter
  • WoehrMiWoehrMi Posts: 5 Bronze 1
    Same issue for me!

    Just installed the update to Visual Studio 2022 v17.8.0 (required for .NET 8 and C# 12) and SQL Change Automation Extension is not working any more, which means I'm unable to build my project. Please provide an updated version as soon as possible!

    Kind regards
    · Share on Twitter
  • wimreywimrey Posts: 10 Bronze 1
    I was really hoping this would have been fixed with the official release of 17.8. This has been an issue in the preview version and multiple bug reports were sent. it's sad to see this product getting so little love from red-gate
    · Share on Twitter
  • stevechisholmstevechisholm Posts: 5 Bronze 1
    Ditto; dead in the water.
    · Share on Twitter
  • Tom_CTom_C Posts: 83 Bronze 4
    Hi all,

    Sorry you're seeing this issue with SCA and Visual Studio, a colleague has already escalated this issue through for the attention of our development team and we hope to have a further update for you soon.

    Appreciate it may not be possible, but SSMS has been suggested as a workaround while we await news from our development team on VS.
    Kind regards

    Tom Claringbold | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • GeorgeousGeorgeous Posts: 3 New member
    edited November 23, 2023 10:16AM
    Tom_C said:
    Hi all,

    Sorry you're seeing this issue with SCA and Visual Studio, a colleague has already escalated this issue through for the attention of our development team and we hope to have a further update for you soon.

    Appreciate it may not be possible, but SSMS has been suggested as a workaround while we await news from our development team on VS.
    Hi all,
    any update on this? I have the same issue 

    Microsoft Visual Studio Professional 2022 Version 17.8.1
    Redgate SQL Change Automation   4.6.23319.2501

    I tried an update to 
    Redgate SQL Change Automation   4.6.23326.2589
    but it's still the same


    <div>2023-11-23 10:38:25.635 +01:00|Information|RedGate.Versioning.Client.Licensing.RedgateLicensing.RedgateLicensor|1| Redgate Client capability version: 2</div><div>2023-11-23 10:38:39.127 +01:00|Error|RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService|1| Could not open a project</div><div>System.MissingMethodException: Method not found: 'Boolean Microsoft.Data.SqlClient.SqlConnectionStringBuilder.get_Encrypt()'.</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Shared.DatabaseUtils.SqlServer.Connection.ConnectionStringParser.ParseConnectionString(String connectionString)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetRawConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.LoadSettings(String filePath, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engines.Migrations.Projects.SqlProj.DatabaseConnections.ProjectDatabasesRetriever.LoadSettings(String filePath, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadProject(Project project)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadDefaultProject()</div><div>2023-11-23 10:38:39.156 +01:00|Information|RedGate.Versioning.Client.VsShell.VisualStudio.Views.ContentSwitcher|1| Hit exception, displaying message to user.</div><div>System.MissingMethodException: Method not found: 'Boolean Microsoft.Data.SqlClient.SqlConnectionStringBuilder.get_Encrypt()'.</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Shared.DatabaseUtils.SqlServer.Connection.ConnectionStringParser.ParseConnectionString(String connectionString)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetRawConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.GetConnectionString(IMsBuildUserSettingsStrategy strategy, ConnectionStringPropertyNames connectionStringPropertyNames, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engine.Projects.ProjectSettings.SqlProj.UserSettings.ProjectUserSettingsLoader.LoadSettings(String filePath, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Engines.Migrations.Projects.SqlProj.DatabaseConnections.ProjectDatabasesRetriever.LoadSettings(String filePath, IProgressLogger progress)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadProject(Project project)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ProjectSelection.SelectProjectService.LoadDefaultProject()</div><br>

    · Share on Twitter
  • WernerNicoWernerNico Posts: 2 New member
    edited November 23, 2023 10:50AM
    Have the same issue.
    In release note for VS 17.8 

    SQL

    • Upgraded Microsoft.Data.SQLClient (MDS) from version 3.0 to version 5.0 in SQL Server Data Tools (SSDT) Read more
    • Two new fields are added to Connect dialogue box
    • The Encrypt property now defaults to true (enabled) when connecting. If a server does not have a trusted certificate configured, the use of Trust Server Certificate set to true may be appropriate. For more details, please refer to the documentation
    Ref https://learn.microsoft.com/en-us/visualstudio/releases/2022/release-notes#sql
    · Share on Twitter
  • clinkeclinke Posts: 18 Bronze 1
    edited November 23, 2023 12:59PM
    The problem lies in RedGate.Versioning.Engine.Shared.DatabaseUtils.SqlServer.dll (C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\Extensions\001rr241.rgs).

    There's a workaround disabling encryption:
    1. In ConnectionStringBuilder, Method  Create, remove property Encrypt
    2. In ConnectionStringFactory, Method ParseConnectionString, pass false to parameter to SetEncryptConnection
    You can use e.g. dnSpy to change this. 

    With Visual Studio 17.8, there were some changes regarding Connection encryption. It is enabled by default now, and some properties changed from value to object types.

    See
    https://learn.microsoft.com/en-us/sql/ssdt/connect-to-an-existing-database-in-sql-server-data-tools?view=sql-server-ver16#EncryptTrustServerCertificate

    All information is provided without guarantee and liability
    · Share on Twitter
  • wimreywimrey Posts: 10 Bronze 1
    Still no update on this? 
    · Share on Twitter
  • dbriskindbriskin Posts: 7 Bronze 1
    I had to rollback to VS 17.7 to resolve this.
    · Share on Twitter
  • tschlichtschlich Posts: 5 Bronze 1
    Any updates on this @Tom_C?
    · Share on Twitter
  • GeorgeousGeorgeous Posts: 3 New member
    edited November 28, 2023 6:52AM
    dbriskin said:
    I had to rollback to VS 17.7 to resolve this.
    I had to do the same but that's not really a solution of the problem.
    · Share on Twitter
  • miguelg_misstipsimiguelg_misstipsi Posts: 3 Bronze 2
    @Tom_C
    Any updates on this?

    · Share on Twitter
  • tschlichtschlich Posts: 5 Bronze 1

    · Share on Twitter
  • chrisqtranchrisqtran Posts: 123 Silver 3
    Hi everyone,

    The developers are still working on a fix for this issue. If you're able to downgrade Visual Studio to 17.7 as a temporary workaround, that should get you up and going in the meantime.

    I appreciate your patience on this and will let you know of any updates that come our way.
    · Share on Twitter
  • DavidVerDavidVer Posts: 13 Bronze 3
    Any updates on the progress here?
    · Share on Twitter
  • AnotherChrisAnotherChris Posts: 1 New member
    Again several days past. @chrisqtran What's going on?
    · Share on Twitter
  • GeorgeousGeorgeous Posts: 3 New member
    I do agree, It's been almost a month when the SCA is not usable with the latest VS and there is still no fix for this available?
    · Share on Twitter
  • daviepdaviep Posts: 7 New member
    @chrisqtran - do we have an update regarding this issue?
    · Share on Twitter
  • MathieuMathieu Posts: 5 Bronze 1
    Agreed, we heavily rely on SCA for our devops flow. Need this fixed asap please. SSMS addin is a workaround but the experience is not so fluid
    · Share on Twitter
  • clinkeclinke Posts: 18 Bronze 1
    I wouldn't be too optimistic. It took months to implement support vor VS2022:
    https://forum.red-gate.com/discussion/88504/will-sca-support-visual-studio-2022

    Also, one of my tickets is in development since June. We can't use latest Change Autimation plugin because of a Newtonsoft.Json dependency error. This was once fixed and in a later version re-introduced.

    Very unstable for us to use CA, we are not happy ...
    · Share on Twitter
  • Tom_CTom_C Posts: 83 Bronze 4
    Hi all,

    Apologies for the delay on resolution for this, I'm really sorry for the disruption this has caused. Our development team have a couple blockers on release of a new version with a fix for this that they are actively working on.

    At present, our advice is still to downgrade Visual Studio to 17.7 as a workaround.
    Sorry I don't have better news but we hope to have further update for you soon.
    Kind regards

    Tom Claringbold | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • clinkeclinke Posts: 18 Bronze 1
    This is not an option for us, we use .NET 8 now. Why are features more important than bug fixes? Our customers would quit for such behaviour. Very unfavourable ...
    · Share on Twitter
  • miguelg_misstipsimiguelg_misstipsi Posts: 3 Bronze 2
    Completely unacceptable!
    As @clinke said, we again paid for your delays in implementing updates and bugs fixed. 
    I believe that this is a critical bug and it doesn't have the right priority.
    Tom_C said:
    Hi all,

    Apologies for the delay on resolution for this, I'm really sorry for the disruption this has caused. Our development team have a couple blockers on release of a new version with a fix for this that they are actively working on.

    At present, our advice is still to downgrade Visual Studio to 17.7 as a workaround.
    Sorry I don't have better news but we hope to have further update for you soon.


    · Share on Twitter
  • Tom_CTom_C Posts: 83 Bronze 4
    My sincere apologies for the delay. Our development team have just released a version including the fix for this, I've tested a build and created a new project and so far so good!
    If you now go to Extensions > Manage Extensions > Update - Redgate SQL Change Automation 2022


    Any issues with this please let us know.
    Kind regards

    Tom Claringbold | Redgate Software
    Have you visited our Help Center?
    · Share on Twitter
  • YLarenteYLarente Posts: 3 Bronze 1
    edited December 18, 2023 7:02PM
    After updating to 4.6.23352.2795 I am getting the following error when trying to open the Database Connection Dialog from within Visual Studio 17.8.3


    <div>2023-12-18 14:00:04.666 -05:00|Error|RedGate.Versioning.Client.VsShell.VisualStudio.ConnectionDialog.VisualStudioConnectionDialog|1| Error in ShowConnectionDialog:</div><div>System.FormatException: String was not recognized as a valid Boolean.</div><div>&nbsp; &nbsp;at System.Boolean.Parse(String value)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.Core.SqlServerConnectionService.GetUIConnectionInfoFromConnectionString(String connectionString, IServerConnectionProvider connDlgServerType)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.VS.VSConnectionMruManager.GetMruList()</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.UI.HistoryPageViewModel..ctor(IDependencyManager dependencyManager, ConnectionPropertySectionViewModel connectionPropertyViewModel, IEventsChannel channel, IConnectionMruManager mruManager, Boolean isConnectionExpanded)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.UI.ConnectionDialogViewModel..ctor(IDependencyManager dependencyManager, IEventsChannel channel, UIConnectionInfo ci, VerifyConnectionDelegate verifierDelegate, ConnectionDialogConfiguration config)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.UI.ConnectionDialogFrame..ctor(IDependencyManager dependencyManager, EventsChannel channel, UIConnectionInfo ci, VerifyConnectionDelegate verifierDelegate, ConnectionDialogConfiguration config)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.UI.ConnectionDialogWrapper.ShowDialog(IntPtr parent, UIConnectionInfo ci, IDbConnection& connection, Nullable`1& result, ConnectionDialogConfiguration config)</div><div>&nbsp; &nbsp;at Microsoft.SqlServer.ConnectionDlg.UI.ConnectionDialogWrapper.ShowDialog(IntPtr parent, UIConnectionInfo ci, ConnectionDialogConfiguration config)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ConnectionDialog.VisualStudioConnectionDialog.ShowSsdtConnectionDialog(Object connectionInfo)</div><div>&nbsp; &nbsp;at RedGate.Versioning.Client.VsShell.VisualStudio.ConnectionDialog.VisualStudioConnectionDialog.ShowConnectionDialog(String connectionString)</div>
    · Share on Twitter
  • stevechisholmstevechisholm Posts: 5 Bronze 1
    I installed the new SCA update, then re-upgraded to VS 17.8 and it looks like I'm all good now.  Thanks for the fix; I'm letting my team know.
    · Share on Twitter
  • miguelg_misstipsimiguelg_misstipsi Posts: 3 Bronze 2
    It seems to run fine for me after the update. Thank you!
    · Share on Twitter
  • daviepdaviep Posts: 7 New member
    It seems the issue was resolved but it so slow building the project. In my case, it took 4 mins and 46 seconds to complete the build.
    · Share on Twitter
  • clinkeclinke Posts: 18 Bronze 1
    Yes, can confirm the error is fixed.
    · Share on Twitter
Sign In or Register to comment.