System.ArgumentException: Keyword not supported: 'trust server certificate'

[zackhowe]

When trying to open/edit a efpt reverse engineer project with a data connection that has Trust Server Certificate defined (either true or false) the action fails with an error in the extension output.

Provide steps to reproduce

Create a Data Connection that defines Trust Server Certificate in the Advanced Settings. When it is initially defaulted to False, and not displayed as bold, It is not added to the connection string, and the reverse engineer works as expected. Once set the True (or False) the ";Trust Server Certificate=True" is append to the Connection String.

Now choose EF Power Tools - Edit and an error appears in the output:

System.ArgumentException: Keyword not supported: 'trust server certificate'.
   at NameValuePair System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, string connectionString, bool buildChain, Hashtable synonyms, bool firstKey)
   at new System.Data.Common.DbConnectionOptions(string connectionString, Hashtable synonyms, bool useOdbcRules)
   at new System.Data.SqlClient.SqlConnectionString(string connectionString)
   at DbConnectionOptions System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(string connectionString, DbConnectionOptions previous)
   at DbConnectionPoolGroup System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, ref DbConnectionOptions userConnectionOptions)
   at void System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key)
   at void System.Data.SqlClient.SqlConnection.set_ConnectionString(string value)
   at new System.Data.SqlClient.SqlConnection(string connectionString, SqlCredential credential)
   at Tuple<bool, Version> EFCorePowerTools.Helpers.ReverseEngineerHelper.HasSqlServerViewDefinitionRightsAndVersion(string connectionString)
   at void EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.VerifySQLServerRightsAndVersion(ReverseEngineerOptions options)
   at async Task EFCorePowerTools.Handlers.ReverseEngineer.ReverseEngineerHandler.ReverseEngineerCodeFirstAsync(Project project, string optionsPath, bool onlyGenerate, bool fromSqlProj)

Provide technical details

• EF Core version in use: (e.g. EF Core 7) EF Core 7 (Which requires the Trust Server Certificate)

• Is Handlebars used: no/yes no

• Is T4 used: no/yes yes

• Is .dacpac used: no/yes no

• EF Core Power Tools version: (found in About dialog - blue questionmark icon on context menu) 2.5.1316

• Database engine: (SQL Server, Azure SQL, Postgres, Oracle, Firebird, SQLite, MySQL) Sql Server

• Visual Studio version: (e.g. Visual Studio 2022) Visual Studio 2022

[ErikEJ]

@zackhowe I assume you are using VS 17.5 with the new Microsoft Data SqlClient DDEX provider?

[zackhowe]

@ErikEJ 17.5.1 Not sure about the DDEX provider. I think this was working prior to a recent VS update....

[ErikEJ]

I implemented a fix for this in the latest daily build, would be grateful if you could try it out.

If you like my free tools, I would be very grateful for a rating or review on Visual Studio Marketplace or even a one-time or monthly sponsorship

[zackhowe]

@ErikEJ I was just able to successfully edit/reverse engineer using a connection with the Trust Server Certificate set. Thanks for the speedy fix!